loharobot.blogg.se - How to change print area in excel after making one page

#How to change print area in excel after making one page how to#
#How to change print area in excel after making one page manual#
#How to change print area in excel after making one page code#
#How to change print area in excel after making one page windows#

Step 1: Open your spreadsheet in Excel 2013. If that setting is correct, then we will check a print setting.

#How to change print area in excel after making one page manual#

The first setting that we will check involves the manual scale of the page. The steps below will assume that there is currently page scaling that is being applied to your Excel spreadsheet, which is causing the printed version of the sheet to be very small.

#How to change print area in excel after making one page how to#

How to Change the Page Scale in Excel 2013 Our guide below will show you two locations to check. Fortunately this is a problem that you can overcome by changing some print settings back to their defaults. This can lead to scenarios where your printed spreadsheet is too small, and very difficult to read. Many times these formatting issues due to the reuse of spreadsheets that were previously adjusted to accommodate sheets that are now a different size. One big one is the print area, which can be a really frustrating thing to solve when only part of your spreadsheet is printing. If StartPageNumber > 0 And StartPageNumber <= TotalNumberOfPages Thenįor CurrentPage = StartPageNumber To TotalNumberOfPages Step 2ĪctiveSheet.I have found that spreadsheets I receive from other people often have some formatting that is already applied. & "Also make sure that the correct printer is selected as the printing will start right away.") & "This number determines wether odd or even pages will be printed. & "Which page do you want to start with?" & Chr(13) & Chr(13) _ & " pages selected in total." & Chr(13) & Chr(13) _ StartPageNumber = InputBox("There are " & CStr(TotalNumberOfPages) _ TotalNumberOfPages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")

#How to change print area in excel after making one page code#

Paste the following code and press start above: Sub PrintOddOrEvenPages()ĭim TotalNumberOfPages, StartPageNumber, CurrentPage As Double Right click on and worksheet on the left hand side and click on “Insert” –> “Module”. Open the VBA editor by clicking on “Visual Basic” on the left hand side of the “Developer” ribbon. Now it is possible to resize the spreadsheet to the window just by clicking the button. Assign the macro created above to that button. Next, create a button using Developer -> Insert -> Form Control -> Button (Form Control). Click the Stop Recording button from the Developer Tab. You still want to print all odd or or even pages? The only option is a short VBA macro. Click in Cell A1 to return the selection to a single cell. You might have to search a little bit for that option.

#How to change print area in excel after making one page windows#

Then the printer menu options – this windows looks different for each printer. Then click on the “Printer Properties” button (number 1 on the image). As usual, you will see the print preview.

Therefore, press Ctrl + p on the keyboard. Most printers offer such option so that you don’t have to worry about odd and even pages. Most printer offer a two sided print option.įirst question: Why do you want to print odd or even pages only? If the reason is that you want to print your Excel sheet on front and back side of the paper, please take a look at the print menu first. For those of you who like to do some VBA programming we’ve also added the corresponding VBA code but we won’t go more into detail here: Header/Footer elementĬode for inserting in Header/Footer window These settings you can also add in different ways by typing the code. If you want to work with the codes, please refer to this table.

Therefore enter “Page ” then click on button 4, type ” of ” and click on button 5. Once you’ve selected a picture with button “11” you can modify it by clicking on button number 12.Įxample: You want to insert “ of 3”.

In most cases, you need at least to define the correct size of your picture.

Just click the button and select your picture.

Besides the file path, you can also insert the file name.

If you only want to insert the path without the file name, type “&”. By default, Excel adds the path and file name.

Insert the file path of your workbook.

This is the date at which you are printing the workbook – not the last save date. Also this number depends on which sheets you are going to print. If you just print the second worksheet of your workbook, the numbering will still start at 1. This number will depend on the sheets you are printing.

Insert the number of the current page.

You can change the font style by clicking on the “A” button (number 3).

Add a custom text by just typing into one of the text boxes.

Now you’ve got many options for defining headers and footers.

Click on “Custom Header” or “Custom Footer”.

Now go to “Page Setup” and navigate to “Headers and Footers”.

Enter the print screen by pressing Ctrl + p on the keyboard.

Follow these steps for inserting headers and footers (the numbers are corresponding to the image on the right hand side): The advantage is that you won’t mix up the printed pages. You can also choose to use the options Fit to Width print all the columns on one page, while the rows can be printed on multiple columns.