Keyboard shortcuts for formatting
Excel Tip #020 Keyboard shortcuts for formatting A lot of us use keyboard shortcuts but when it comes to formatting a spreadsheet, these shortcuts go for a toss as formatting relies on mouse. But there are few simple & effective shortcuts which would help us a lot. Below are some... CTRL+1 – Format anything This shortcut is powerful. Select anything (cells, chart objects, drawing shapes, pictures etc.) and press CTRL+1 to instantly launch format dialog box. ALT EST (or ALT HVE) – Format painter If you want to copy the formatting from one thing to another (like formatting of a bunch of cells to another range, a chart to another chart), you can use Format painter. Simply copy the original object (CTRL+C), select the target object and press ALT+EST (one key after another). You may also use ALT+HVE (again one key after another) in all modern versions of Excel. ALT HH – Fill color Now comes the tricky one. If you want to fill some color in a chart object, drawing shape,...