As far as Excel shortcuts go this really ranks as one of my favourites. I don’t ever go to File Save as when I can simply hit F12. Yes that’s it F12 and my Save As dialog box appears.
Give it a go…you wont look back!.
Helping YOU To Excel At Excel
by Barbara
by Barbara
I am sure you all know how to use the AutoSum, just click the Excel’s AutoSum button on the Excel Ribbon that looks like this
from a cell next to a row or column of data and Excel will automatically Sum these numbers and we don’t even have to type a formula or drag a formula down a column of values or across a row of data.
Give it a go, you won’t look back.
1. Awesome Excel Shortcut For Borders
2. Fast Fun Ways To Learn Formulas
3. Hot Excel Tip -Convert Temperatures
by Barbara
So, you think you know some pretty nifty shortcuts in Excel?. How’s about this one, race you to draw borders around your cells……
1. Move Around Excel Worksheet With The Keyboard
2. A Fast Fun Way To Learn Excel Formulas
by Barbara
Here’s a great shortcut you may not have heard of or maybe you have. I know I was really pleased when I was shown it, and those people who like to use the mouse a lot to navigate will like it as well, I guarantee.
Lets rock and roll with it then…..when you select a cell in Excel, as you know there is a black square put around the cell, if you double click on one of the border lines of the cell, then Excel will move the cell selection in the direction of that cell. i.e of you double click the bottom of the cell border the selection move downwards.
Here is an example.
Select a cell within a table of data
Double click the bottom border of the cell
Do NOT double click the fill handle tho’!
Excel will take the a cursor and select the last cell in the column that contains any data. The same thing will happen on any cell border selected and move to the last cell in the appropriate direction with any data in it.
Now then you may be thinking that is the same as using CTRL+Left Arrow, Right Arrow etc etc?. If the original cell you selected has data in it then they will indeed both act in the same way.
BUT
If the original cell is not within a data table then the result is not the same.
If you select an unused cell directly to the right of your data table and double click on cell the left cell border Excel will take you to the first column that contains data in your table. If however you are a few cells removed from the edge of your data table by carrying out the same actions Excel will take you to the right of your data table.
Have a click around with Excel and this shortcut to see how it behaves..its cool.
1. Perform Inexact Searches In Excel
2. Search For And Highlight Invalid Data In Excel Worksheets
3. Open Multiple Windows For The Same Workbook
by Barbara
We are all in a hurry, most of the time, so I thought I would share one of my all time favorite Excel keyboard shorcuts.
How to Close An Excel Workbook
If you want to close a selected Excel workbook really quickly the just hit CTRL+W
How to Close Out Of Excel
If you need to exit out of Excel quickly then use ALT+F4
Give them a go they are real time savers.
1. Quickly Select All Cells In Your Excel Worksheet
2. Open Your Excel Workbook To A Specic Sheet And Cell
3. Limit The Usable Area In A Worksheet
Want to do discover some amazing things you can
do with Excel?
You Can Discover 101 Of Excels Little-known Secrets
That Have Been Hiding Right Under Your Nose.
These Secrets Are Guaranteed To Boost Your Excel
Skills And Productivity Far Ahead Of Everyone Around
You.
Imagine! You The Excel Expert! Or Office Guru Grrrrrr
This really is a great resource for many AH HAH! moments when using Excel.
[/callout]