Скачать или смотреть Excel - Print Spreadsheets with Column Headers and Row Numbers | Excel Printing Tips - Episode 341

Microsoft Excel Tutorial - Print Spreadsheets with Column Headers and Row Numbers | Excel Printing Tips.

Welcome back to the MrExcel podcast! In today's episode, I'm going to share a useful trick for printing your spreadsheets with the column headers and row numbers included. This may seem like a small detail, but it can make a big difference in the clarity and organization of your printed documents.

By default, when we print a spreadsheet, the row numbers and column headers are not visible. However, there is a simple solution to this. Just go to File, Page Setup, and on the Sheet tab, check the boxes for "Print gridlines" and "Print row and column headings." Click OK and then go to Print Preview to see the changes. Now, your printout will look just like your Excel screen, with the row numbers and column letters clearly displayed.

You may be wondering why you would want to do this. Well, there are a couple of handy tricks that this feature allows for. First, if you use the Ctrl+~ shortcut to show formulas in your worksheet, you can then print a copy of the sheet with the formulas visible. This can be helpful for double-checking your formulas and ensuring they are correct. Additionally, you can also choose to display comments at the end of the sheet under File, Page Setup. By printing the row numbers and column letters, you can easily match up the comments with the corresponding cells.

So, the next time you need to print a spreadsheet, remember this trick to include the row numbers and column headers. It may seem like a small detail, but it can greatly improve the readability and organization of your printed documents. Thanks for tuning in to this episode of the MrExcel podcast, and be sure to join us next time for more helpful tips and tricks!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...


Table of Contents:
(00:00) Introduction to printing spreadsheets with column headers and row numbers
(00:25) How to enable row numbers and column headers for printing
(00:42) Benefits of printing with row numbers and column headers
(00:52) Using the Ctrl+~ trick to print formulas with row numbers and column headers
(01:07) Displaying comments at the end of the sheet with row numbers and column headers
(01:29) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
How to print spreadsheets with column headers and row numbers
How to view row numbers and column letters in print preview
MrExcel podcast on printing techniques in Excel
Page Setup options for printing in Excel
Printing comments on Excel sheets
Printing Excel sheets to match the screen appearance
Printing gridlines and row/column headings in Excel
Printing worksheets with formulas displayed
Show Formulas mode in Excel
Tips for printing Excel spreadsheets accurately
Tricks for checking formulas and comments when printing in Excel
Using row and column headings for printing


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...

How to print your worksheet with the row and column headings visible. Episode 341 shows you how to make your printout look just like your Excel screen, plus two reasons why you would want to do this. Learn how to print formulas instead of values and how to print your cell comments at the bottom of the sheet.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!