Teach Microsoft Office
Online Video Tutorials for Microsoft Office
Request Tutorial
Excel Help and Consulting
Video Player Demo
User Testimonials
Easy to Follow and Great Content
Awesome tutorials. This is great work; thanks a lot for all of these tutorials, and at a great price. The tutorials are easy to follow and understand and are very valuable for me. Teachmsoffice.com has helped me a lot in terms of increasing my Excel skills and learning how to master Excel. Keep up the good work!
- Sarah M.

Thank you so much!
Thank you so much! My professor was giving me a hard time with this...so I told him I will just figure it out on my own and this site really helped me figure everything out!!
- Ms. R

Thank you and godbless
My text book really sucks and I'm very thankful that you have all of these tutorials. I finished my last two questions because of your site! Thank you and godbless.
- Rob V.

Amazing Videos
Just wanted to say that your videos are amazing. I'm watching them and they really help me understand. The way you explain and go through everything is amazing. Thank you soo much!
- Design X

Saved a Ton of Time!
You have just saved me so much time, I cannot thank you enough!
- L. J.

Thank You!
Thank you for sharing these important tips. Your voice is clear and the steps are clear. It is easy to follow. Thank you!
- Kent

Saved Me Time
Thanks for the tutorials, I never had to do this before today and I needed it done very quickly. These videos saved me time I didn't have!
- Mitchel S.

Thank You!
Thank you! Helped me so much!
- M. Clean

Excellent Tutor
I was just listening to the tutorial online and I must say that the tutor is doing an excellent job.
- D. B.

Sign Up to View Tutorials
Purchase Subscription

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
Purchase Subscription
Downloadable Files: Yes
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training copy paste values keyboard shortcut excel tutorial help tip trick
Bookmark and Share
View All Tutorials - 375 Tutorials - 36 hours 28 minutes of Content
Similar Tutorials
Tutorial Length
(mm:ss)
Office Program
Copy and Paste Values Using a Keyboard Shortcut in Excel 3:28 Microsoft Office Excel
Auto Resize Columns Using a Keyboard Shortcut 3:30 Microsoft Office Excel
Clear All Formatting from Cells with One Mouse Click 2:27 Microsoft Office Excel
Remove Comments from an Entire Worksheet with One Mouse Click 2:30 Microsoft Office Excel
Select All Cells that Contain Formulas and Functions 2:22 Microsoft Office Excel
Remain in the Same Cell After Hitting Enter 2:08 Microsoft Office Excel
Remove Gridlines from a Worksheet in Excel 1:50 Microsoft Office Excel
Remove Dotted Print Lines in Excel 2:40 Microsoft Office Excel
Print Gridlines in Excel 2007 2:43 Microsoft Office Excel
Hide the Ribbon Menu in Excel 2007 1:16 Microsoft Office Excel


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
 
Official PayPal Seal SSL
Join TeachMsOffice.com on Facebook
Follow TeachMsOffice.com on Twitter


Microsoft Office Tutorials | Office Tutorials - Excel Word PowerPoint | HD Tutorial Video Player Overview | About TeachMsOffice.com

TeachMsOffice.com provides HD Online Video Tutorials and Training for Microsoft Office programs such as Excel, Word, and PowerPoint. We use a specialized video player interface to teach a vast list of Microsoft Office Tutorials and we add new tutorials on a weekly or monthly basis.