I used to be able to enter data in a row in an Excel spreadsheet by tabbing across cells, then when I was finished and hit enter the focus would move to the first cell in the next row (or the cell in the next row underneath the one where I first started tabbing across).
So:
Start in A1, tab...
I have a spreadsheet that has conditional formatting on 2 adjacent cells (G5 & H5). The formatting uses a formula to highlight the cells if the sum of their values is higher than the value in a third cell (D5). The conditional formatting works fine.
However, having entered values into each of...
Hello good folks,
I am thinking about creating a spreadsheet to keep track of items (lets call them recipes) by keywords (lets call them key ingredients). Before I actually start to type in huge wodges of data I need to ensure I understand how to format it. So what I thought was:
Data Sheet...
I have been waiting for my organisation to upgrade to Excel 2013 so I could use Distinct Count in a pivot table I created some time back. I was shattered to find that I lost the ability to group dates.
In the attached file, I wish to have a pivot table that shows me the number of meetings held...
I have a sheet that is protected, with some columns enabled for data entry. Normally when you enter data into a sheet, pressing TAB to go from column to column, when you press Enter you go to the first column (or the column you started in) in the next row. However, with my protected sheet...
I am in Australia so have my dates formatted as dd/mm/yyyy. I wish to show the month name for a date, so I can set up a pivot table for the data. I use the =Month() formula to obtain the month number, then format the cell with mmmm to show the name, however no matter what my date the month...