![]() ![]() If you do no not select a range to print, Excel determines the location of all cells that contains data and prints them. The reason for this is that Excel assumes the user has one print range on a sheet and it is saving you time by having Active Sheet(s) pre-selected. Active Sheet, the selection (what is highlighted) or the entire workbook.Īs mentioned above, Excel prints the entire sheet by default as Active Sheet(s) is always the default.Ĭlicking on the Printer Tool, is the same as File Print (in the menu) and, as we have already seen, the entire sheet will print. There are three choices on what Excel is to print. Note the selection defaults to Active Sheet(s), which means the entire sheet. ![]() If you highlight a range and click on File Print (in the menu), click on the Selection choice, then the highlighted range will be printed.īy default, Excel prints the entire sheet.If you highlight a range to be printed and click the Print Tool the entire sheet will be printed, the highlighting of the range is ignored by Excel. ![]() If you do not highlight a range and click the Print Tool, the entire sheet will be printed.Many users are not quite sure exactly how Excel determines what range to print when the Printer Tool used. The original article, updated for 2018, follows: In other words, we do need to care about printing and all the related issues. But was is a PDF file? Technically it’s an advanced form of printing to a file. So in today’s environment we don’t need to worry about printing? Maybe, but it’s a short sighted argument as PDF files are now an integral part of our paperless world. Without worrying about printing a spreadsheet can be of most any size and actually present more information in a free flowing environment. In today’s paperless world printing is less of a priority. This article was originally written in about 1995 when printing was a key task in any Excel project. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |