|
Home > Format > Tips > Worksheet Excel Formatting Tips
|

Open the Format Cells with the keyboard or mouse, to change any of the formatting options for the selected cells
The Format Cells dialog box opens, and you can click any of the tabs, to change the formatting options for the selected cells.

Do you use this mouse shortcut to quickly copy formatting? I was helping someone with conditional formatting, and we set up the rules in the first cell.
Then, to copy those rules to the cells below,
The animated screen shot below shows the steps -- I find this quicker than using the Format Painter.
If you prefer to use the keyboard, there is a long list of Excel Keyboard Shortcuts on my website.

In the screen shot below, all the cells are the same font and font size - Calibri 11.

In this short video, I show how to fix the problem, when number signs appear in narrow columns. There are written steps below the video.
To prevent number signs from replacing the real numbers, you can turn on a setting for the cell's font.
The setting is named"Shrink to Fit". With this setting turned on, if you make columns narrower, the font shrinks, if necessary, so all the text fits in the current column width. This setting will save you time, because you won't have to constantly tweak the font sizes or column widths.
To change the Shrink to Fit setting, follow these steps:
After this setting change, the font will get smaller, if the column is too narrow to show all the text. However, the font will NOT get bigger than the set font size, if you make the columns wider.
If you're trying to select a custom colour, the colour palette that opens is very small, and it's hard to click on the colour you need.
Use this quick trick to make the job easier.
In the screen shot below, I'm pointing to the title bar, and ready to double-click there.

While working on a worksheet, you might want to format a cell, or the text inside a cell.
To do that, you can use the formatting commands on the Excel Ribbon's Home tab. Or, to same time, use one of Excel floating mini toolbars.
There's a floating toolbar that appears when you select text in a cell. It has a few commands for formatting text.

To turn this mini toolbar on or off, follow the steps below:

There's another mini toobar that appears when you right-click on a cell. This toolbar is larger, and has commands for text formatting, and cell formatting.

Unfortunately, there isn't a setting in Excel Options, where you can turn the right-click Cell Format mini toolbar on or off.
Instead, you can use the following macro to show or hide this toolbar.
Sub MenuFloatiesToggle()
'contextures.com
'show/hide right-click
'mini toolbar
With Application
.ShowMenuFloaties _
= .ShowMenuFloaties
End With
End Sub
To save this macro, I pasted the code into my Personal Macro Workbook, which opens automatically when Excel starts.By storing it there, I can use the macro from any workbook, while Excel is running.
To run the macro:
Assign Macro Shortcut
To make the macro easier to run, you can assign a shortcut key.

To show an electromagnetic spectrum in a range of 6 cells, you can use a 2-color gradient fill in each cell.
Thanks to Robert Lepper, for sharing this tip. He used this technique to help with a homework assignment.

To show a color spectrum in an Excel spreadsheet, like the one above, each cell is filled with a 2-color gradient. Each adjacent cell starts with the finishing color of the cell to the left.



Get the sample formatting workbook. The zipped file is in xlsx format, and does not contain macros.
Don't miss my monthly Excel newsletter! You'll get quick tips, article links, and a bit of fun. Add your email, and click Sign Up.
Next, when you get my reply, click the Confirm button. I add this step to protect you from spam!
FAQs, Worksheet Functions and Formats
Last updated: November 10, 2025 3:58 PM