Getting started with Filter buttons.
Add Filter buttons to your data using Sort and Filter, then Filter. Found on the Home Menu. (Shortcut keys: Alt H, S, F) If you add filters to your data, you can access the sorting from the filter button. Sort A to Z (Smallest to Largest) and Z to A (Largest to Smallest) are available […]
Get your life in order, or at least your data with Custom Sort.
To get your data in just the right order, use Custom Sort. Found on the Home Menu, under Sort & Filter. (Shortcut keys Alt, H, S, U). Make sure you have selected a cell within the data you want to be sorting, otherwise Excel gives you an error message. Once you have the Custom Sort […]
Get Sorted, with Sort
If you have data in a list and you want to change the order, then you need to Sort. The simplest place to find sort is on the Home Menu, Under Sort & Filter. (Alt, H, S, S) If you have pre-selected a cell in the column you want to sort by, just choose Sort […]
Can I check the spelling in my spreadsheet?
Yes, you can spell check your Excel spreadsheet. On the Review Menu, Spelling. Shortcut keys: Alt, R, S.
Much more efficient manual entry
As much as I like to automate tasks, and avoid manual entry, sometimes it is unavoidable. But when it is required, it too can be done in an efficient or inefficient way. I see people type into one cell, then use their mouse to click in the next cell to enter the next piece of […]
Autosum shortcut key
Format: to get cells looking just the way you want them to.
You can Format a cell (or cells) to make then look, just as you want. To get the Format Cells option box, either, Right click(Shortcut key Shift + F10) a cell and choose Format Cells…, or go to Home Menu, Cells Section, Format drop down, and choose Format Cells (Shortcut keys Alt, H ,O, E) […]
Format: Protection Section.
In the continuing mis-named Cells section of the home menu is the Format drop down, that contains the Protection Section where you can Protect Sheet… or Lock Cell. Shortcut keys: Alt, H, O then P or L. Locking a cell only has an effect once you Protect the Sheet. By default cells are Locked. The […]
Three things I need you to know: Sheets
In the continuing mis-named Cells section of the home menu are three things you can do with Sheets. Rename, Move or Copy Sheet.. and Tab Colour. Short Cut keys; Alt, H, O then R, M or T. Each of these can also be done by Right Clicking on the sheet name. If you want to […]
Hide and Unhide: Rows, Columns, and Sheets.
Within the Home Menu’s slightly misleading Cells section, there is the Format menu, which includes a Visibility section. Here you can Hide & Unhide, rows, columns or whole sheets. To hide the row that is currently selected, just choose Hide Rows. To hide more than one row at once, select cells in all the rows […]