Tag Archives: format

HR Dashboard Tip: Copy & paste chart formatting in Excel 2007

Sometimes you want to show several graphs with the same formatting or brand colours in a single HR management dashboard. After fiddling around selecting the exact design for your first chart you realize you have to remember it all and click through all the same options again. But there is another way!
First you need to click on your first, formatted graph and press CTRL+C to copy it. Then select the new, unformatted graph and press Alt H,V,S,T and then Enter. It may seem a bit long for a shortcut, but if you deal with dashboards regularly it can save a lot of time and ensure that your presentation is consistent. If you really can’t remember the shortcut keys, on the left side of the Home tab you’ll find the Paste dropdown. Select paste special and then formats. You’ll still save time.

Excel Keyboard Shortcuts – Control with Symbols

Another selection of keyboard shortcuts. Press Control and the following symbols:

 

` – Toggles between displaying cell values and formulas in the current worksheet.

~ – Cell format is General.

! – Cell format is Number with two decimal places, commas, and minus symbol for negative values.

@ – Cell format is Time hour and minute, and AM or PM.

# – Cell format is Date (dd-mmm-yy).

$ – Cell format is Currency (with 2 decimal places and negatives in brackets).

% – Cell format is Percentage (with no decimal places).

^ – Cell format is Exponential with two decimal places.

& – Adds outline border on selected cells.

* – Selects the range of cells around the active cell.

( – Unhides all hidden rows in the selection.

) – Unhides all hidden columns in the selection.

– – Delete the selected cells.

_ – Removes outline border on selected cells.

+ – Insert cells.

; – Enters the current date.

: – Enters the current time.

‘ – Copies a formula from the cell above.

” – Copies the value from the cell above.

Learn Any Area of Excel using these 80 Links

Here’s a fantastic post from Chandoo, a prolific Excel blogger that I follow: http://chandoo.org/wp/2011/12/12/learn-excel-by-topic/

The post contains links to 80 different lessons across a wide spectrum of Excel functionality.

Check it out and see what you can learn.

If there’s an Excel topic you want to know more about just tweet @xlcalibre, e-mail admin@xlcalibre.com.

Excel Keyboard Shortcuts – Easy as Control + 123…

Continuing our series of Microsoft Excel Keyboard Shortcuts, we’re looking at what the number keys do when you press them with Control…

1 – Format cells

2 – Bold

3 – Italic

4 – Underline

5 – Strikethrough

6 – Hide/Unhide Object

7 – Hides or displays the standard toolbar

8 – Hides or displays the outline symbols

9 – Hide selected row(s)

0 – Hide selected column(s)