Can I check the spelling in my Excel spreadsheet?
Yes, you can spell check your Excel spreadsheet. On the Review Menu, Spelling. Shortcut keys: Alt, R, S. There are other handy functions here as well. Workbook statistics tells you what your current sheet, and the workbook contain. Number of tables, where the last cell is, how many sheets there are, useful stuff if you […]
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 […]
Change the way you see the cell: Format Section.
The Cells section of the Home Menu, holds the Format menu, where you can get the Cell Size just the way you want it. You can adjust the way the cells in the sheet look by using the Cell Size Section. Row Height allows you to type in a number for the row height. Of […]
Back to basics continued, more formatting options for cells.
You can format a cell in multiple ways using the Number section on the Home Menu. You can format a cell to be Time. There are a number of different options to choose from for how the time is displayed. To access the first three for these options use the More Number Formats and then […]
Back to basics: Formatting
Covering some of the essential knowledge when first starting to use a spreadsheet, here we will cover some Formatting of cells. On the Home menu, is a section called Number. Which is slightly misleading, because it is about a lot more than numbers. This is where you can set how the user sees the information […]
Freeze, in the name of being able to see what is what.
When you have a large sheet and you want to be able to see the top rows, even if you have scrolled down, then Freeze Panes is your friend. For example, if you have headings in the top row and want to be able to see them, even when you are at the end of […]
Make your spreadsheet look less like a spreadsheet.
If you want your spreadsheet to look less like a spreadsheet, or you want more space for your data when showing it to others, then you can change the look of your sheet with a few clicks. Turning off the gridlines and the headings (the letters across the top, and the numbers down the side) […]
Pivot Tables are amazing!
I was reminded again this week how great Pivot Tables are. If you haven’t used these little beauties in your Excel workbooks you might be missing out. Sometimes, they can require a little bit of manipulating to get your data into a state that is ready for a Pivot Table, but it is totally worth […]
Fitting data into a cell and getting it just right.
When the information you want to enter into a cell is too long for the width of the cell you would like, you can use Wrap Text. This will fit the information to the cell by expanding it down to fit. Find Wrap Text on the Home menu, in the Alignment Section. (Shortcut keys Alt, […]