Excel navigation tips from AccountingWEB members

Alt+PageDown moves one screen to the right
Alt+PageUp moves one screen to the left
(on the same worksheet)

The most useful additional 'custom' icons on my toolbar are Freeze Panes, Set Print Area, Paste Values, Clear Border and Light Shading.

A useful one I recently came accross is Ctrl D
This copies the contents of the cell immediately above.

I don't think this one is in the above list either.
To show formulae set in your sheet, type Ctrl + ` (key to the left of the 1 on the top row). This toggles to show formulae and values.
This is a great item - there are already several tips new to me just in a cursory look through - I especially love filling in a formula down a column just by clicking on the black corner of the highlighted cell.

the best bit of advice i can give is to learn to customise the toolbars.

the example below re copying and pasting can easily achieved by having the appropriate icon on your toolbar. i have one to paste values, one to paste formula etc. I also use icon for addding/deleting rows/columns.

you can also customise your toolbars and the resultant dropdown menus.

have a go!

Don't think this one is in the list above.

Ctrl + Tab to cycle through open Excel files

To highlight the whole spreadsheet from top left to bottom right, press Home then hold shift and press End then Home again.

Paste special is a fantastic function for getting rid of formulas, copying formulas or formats, transposing, etc. Highlight what you want to "paste special" then right click your mouse and select paste special to see what you can do.

The most useful function I have ever come across is the "visible cells only" function - this is well hidden and you wouldn't know about it unless someone has told you about it!! I use it when I am subtotalling and I want to copy or format just the subtotals without touching the data. To do this you run your subtotal function, then click the "2" on the bar that comes up to the left to collapse the sheet to display just the subtotals. Then using the menus select Edit - Go To - Special - Visible Cells Only - OK. Then you will see only the visible cells are highlighted (you can un-collapse the subtotal to see this). From here you can copy and paste, or another useful tip is if you want to format just the subtotals, say, by making the subtotals bold or double underlined, etc.

The shortcut for visible cells only is Alt-;(ie semi-colon) - far quicker than looking for it through the menus

back in the dim distant past i asked a question about subtotals after sorting and was advised to use a pivot table which was in retrospect blindingly obvious. there is however an equally efficacious method using sort & subtotals, maybe D Carter can show us the best way to use them

I must admit, I am a mouse/menu man but I will use Alt-; in the future. Thanks for that!!