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 […]
Change the way you see the cell: Format Section.
The Cells section of the Home Menu, holds the Format menu. 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 course, you can also changed the row height by taking your cursor to […]
Cells, but really so much more.
The Cells section of the Home Menu on #Excel is slightly mis-named in my opinion. Here you can insert and delete cells, but you can also insert and delete whole columns and even whole sheets! (Alt – H – I/D) Clicking on Insert or Delete brings up very similar menus. Insert/Delete Cells…, Insert/Delete Sheet Rows…, […]
Doing it in Style…
The Style section on the Home Menu gives easy access to set formatting for cells that can be a good place to start. There are a number of set options you can select from rather than having to customise your own formatting. There are also some common number formatting options. Comma [0] and Currency [0] […]
Back to basics continued, more formatting options.
Carrying on with some basic formatting 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 the Time […]
Back to basics
It has been just over a year since I started writing Excel Tips once a week. Going back over what I have written about, I have realised I haven’t covered some of the most basic/fundamental features in Excel. So, that is my inspiration for my next few blogs! On the Home menu, is a section […]
Automate Your Excel Tasks…
You can automate tasks in Excel. This is done via macros which are coded in a language called VBA. You don’t actually need to be able to write code to benefit from macros. Excel enables you to record actions and it writes the code for you. You can then tell it to repeat those actions. […]