Copy and Paste Values Using a Keyboard Shortcut in Excel
This tutorial shows you the keyboard shortcut for copying and pasting values in Excel. This will allow you to take any formula or function and turn it into the value that it outputs. This is a great technique to use when you need to turn dynamic values into hard-coded values in Excel.
| Tutorial Length (mm:ss): |
3:28 |
Sign Up to View Tutorials
|
| Downloadable Files: |
Yes |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training copy paste values keyboard shortcut excel tutorial help tip trick |
This tutorial shows you a keyboard shortcut for Excel that will allow you to quickly and easily automatically resize columns in Excel. This keyboard shortcut works great for any situation that requires columns to be resized and it will save you a lot of time and work resizing columns in Excel.
| Tutorial Length (mm:ss): |
3:30 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training auto resize columns keyboard shortcut excel automatically resize tip trick |
Learn how to quickly and easily remove all formatting from cells in Excel. This tutorial shows you how to select individual cells, multiple cells, and an entire worksheet and then remove any and all formatting from those cells. This technique even removes number, date, text, etc. formatting from cells.
| Tutorial Length (mm:ss): |
2:27 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training clear formatting cell formats remove excel quick easy mouse click spreadsheet |
This tutorial shows you how to quickly remove all or just a selection of comments from a worksheet in Excel. This tip allows you to save a lot of time because you will no longer have to individually select each comment in order to delete it. Deleting or removing comments from cells in Excel is especially important when you need to clean up a spreadsheet before you send it out to someone.
| Tutorial Length (mm:ss): |
2:30 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training remove delete comments worksheet cells excel spreadsheet quickly tip |
This Excel tutorial shows you how to quickly and easily select all cells that contain a formula or function. This method allows you to identify cells that have hard-coded values and cells that contain a formula or just a function. Also, this method is non-invasive, which means that it won’t affect the appearance of your Excel worksheet.
| Tutorial Length (mm:ss): |
2:22 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training select cell formulas functions all excel worksheet spreadsheet quickly |
This tutorial shows you how to keep the current cell active after you hit the enter key in Excel. This allows you to input data into a cell without moving away from that cell after you hit the enter key. This is a great Excel tip to learn and will save you a lot of time and work in the long run.
| Tutorial Length (mm:ss): |
2:08 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training same cell hit enter key excel input data remain stay enter keyboard |
This tutorial shows you how to remove gridlines from a worksheet in Excel. Gridlines are the default outlines of each cell in a worksheet in Excel. When you remove these gridlines, you are able to make a cleaner looking spreadsheet interface in Excel.
| Tutorial Length (mm:ss): |
1:50 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training remove gridlines cell excel worksheet cell outlines clear boxes |
This tutorial shows you how to remove the dotted print lines that appear in a worksheet in Excel after you go to Print Preview or after you print the worksheet. These little lines are actually page break lines and they can be very annoying. This tutorial shows you how to quickly and easily get rid of these little dotted print lines.
| Tutorial Length (mm:ss): |
2:40 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training remove dotted print lines clear show page breaks excel printing preview |
This tutorial shows you how to print gridlines in Excel. When you open a new spreadsheet in Excel, the little box or cell outlines that you see are called gridlines. By default, gridlines do not print from Excel. This tutorial shows you how to make gridlines show up when you print a worksheet from Excel.
| Tutorial Length (mm:ss): |
2:43 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training print gridlines cell outline border box excel view tip trick spreadsheet |
Learn how to hide or minimize the Ribbon Menu in Excel 2007. Hiding the Ribbon Menu in Excel 2007 allows you to have more space to work and a cleaner looking interface in Excel. This tutorial also shows you how to unhide the Ribbon Menu.
| Tutorial Length (mm:ss): |
1:16 |
| Microsoft Office Program: |
Microsoft Office Excel |
| |
|
| Keywords: |
training hide ribbon menu excel 2007 remove minimize get rid of tip trick |
