When working in Word, PowerPoint, Excel and Visio and you need to copy an object(Shape, picture,chart etc)and all its formatting, rather then using the usual copy and Paste, try using CTRL + D. This will simply duplicate the object you have selected including all your editing and formatting options.
When you first open PowerPoint, the default folder (Open or Saving) is Documents. To change this, go to the File Tab (Backstage view) and select options. In there on the left is the save option and on the right you will see the default file location.
When you first open Word, the default folder (Open or Saving) is Documents. To change this, go to the File Tab (Backstage view) and select options. In there on the left is the save option and on the right you will see the default file location.
When you first open Excel, the default folder (Open or Saving) is Documents. To change this, go to the File Tab (Backstage view) and select options. In there on the left is the save option and on the right you will see the default file location.
The next time you are looking to move through the worksheets in your workbook using the navigation keys (buttons found to the left of sheet 1), don’t left click, right click instead, this should bring you a list of all the worksheets in that workbook.
Highlight all cells (See shortcuts), switch on filters. From one of the drop down menus, deselect everything and then choose just the blanks option. Then Highlight and Delete
Highlight all Cells, this time go to the home tab and the Find & Select button. From there select go to Special; in that dialog box choose blanks. Right click on any highlighted area and delete. (Make sure these are blank rows or columns not individual cells).
|Ctrl+Shift+F3||Create Names From Selection|
|Ctrl+Shift+F||Fomat Cells Font Tab|
|Ctrl+Shift+P||Fomat Cells Font Tab|
|Ctrl+Shift+`||Format Cells -
|Ctrl+Shift+1||Format Cells – Number Format|
|Ctrl+Shift+2||Format Cells – Time
|Ctrl+Shift+3||Format Cells – Date Format|
|Ctrl+Shift+4||Format Cells -
|Ctrl+Shift+5||Format Cells – Percent Format|
|Ctrl+Shift+6||Format Cells -
|Ctrl+Shift+7||Format Cells – Apply Border|
|Ctrl+Shift+-||Format Cells – Remove Border|
|Ctrl+Shift+=||Open Insert Dialog
|Ctrl+Shift+’||Copy Cell Value Above|
|Ctrl+Shift+||Select Unequal Cells|
|Ctrl+Shift+Space Bar||Select All|
|Ctrl+Up Arrow||Move to Next Cell
With Data Above
|Ctrl+Down Arrow||Move to Next Cell With Data Below|
|Ctrl+Space Bar||Select Column|
|Ctrl+BackSpace||Goto Active Cell|
|Shift+Left Arrow||Select Left|
|Shift+Right Arrow||Select Right|
|Shift+Up Arrow||Select Up|
|Shift+Down Arrow||Select Down|
|Shift+Space Bar||Select Row|
|Ctrl+Shift+Right Arrow||Select all cells to the Right or all cells with data|
|Ctrl+Shift+Left Arrow||Select all cells to the left or all cells with data|
|Ctrl+Shift+Down Arrow||Select all cells Below or all cells with data|
|Ctrl+Shift+Up Arrow||Select all cells Above or all cells with data|
Unfortunately, there are still people out there that either are copying one cell at a time, or clicking and dragging down to copy formulas all the way down a list/column. No Need, let Excel do the work for you.
Double-click the fill handle(little box down the bottom right hand corner of cell selected) to automatically fill down when your formula resides aside of other data. It’ll stop when there’s no data alongside it any more or the first break in the data.