Custom Spreadsheet Solutions
Productivity – powered by Excel

How to fit in… your data into a cell.

Fitting data into a cell can be tricky, but with a few simple tricks and tips, you can fit the data into the size and shape of cell that you want. Resize your columns. You can change the width of an individual column (or row height) by moving your mouse pointer to the line between […]

Powerful Filter Button Options.

Once you have added Filter buttons to your data, either via the home menu or because you have a table, you have a lot of options on how to use them. Filter by Color – if you have colours on your cells, either from formatting or conditional formatting, you can use this to filter just […]

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 […]

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 […]

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 […]

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] […]