printing

Hi all, I have a graph that links to a pivot table. The graph shows data from students. We have 225 students. Is there a way of printing the individual graphs for each student automatically without having to change the filter each time and pressing print 225 times? Many thanks in advance! Russ

I have a spread sheet where i need to print cells a1-p4 and b6-p461 but not A6-a461 any thoughts.....

I've created a expense report with a check box (form control) to indicate if paid for with company credit card. When printing the expense report the check box shrinks to almost unreadable. I do have it custom scaled to print all columns on one page. Is there a way to print without changing the...

Hi All, despite much searching and trials I almost have what I need but cannot work out the last bit. I have 7 sheets as part of a training course session for each day of the week and two other sheets that have various stats on them drawn from the formula on the Monday to Friday sheets. The...

I am finding confused for printing the userform. Please help for creating excel VBA code for printing userforms.

Hi My computer is printing the spreadsheet only (cell only), leaving out the contents. It is printing the cells only but not the contents. How do I fix it? Stan

Hi, I've googled, searched forum, but haven't found any solution for it. In excel 2010 I've put a washed out watermark for an invoice behind a table with contents, looks fine, but when printing the image, already in print preview the image of watermark comes forward and therefore covers the...

I am looking to set up a Print Area on a sheet that will remain even when I delete columns. Currently my print area is A1:G24 and when I delete columns A and B, my print area becomes A1:E24. I would like to set up the print area so when columns within that range are deleted, the data that moves...

Hello, i am working on a sheet the generates a report in a friendly format and prints it the way this works is by having a unhidden area that the user generates information for some of this information is copied over to a hidden area which is the area that is printed when running the macro...

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> 1000 3/25/2019 Monday 08:14:53 16:43:05 08:28:12 08:28:12 1000 3/26/2019 Tuesday 08:16:12 17:04:13 08:48:01 08:48:01 1000 3/27/2019 Wednesday 08:25:33 -- -- -- 1012 3/2/2019 Saturday...

Lets say, for example I have a spreadsheet with data in column B-K, and the potential for data in row 1-100. Is there a way, using some sort of flag to tell Excel only to print rows that contain said flag in Column "A"? Alternatively, I know a complete spreadsheet is 10 pages long, if data is...

Hi I can print Dictionary values to the immediate window by running the code below, but I wanted to know how I print "all" the Dictionary values into an Excel sheet? Public Sub DictionaryExamples() Dim exampleValues As Variant Dim i As Long Dim aKey As String Dim aValue As...

Looking in column C I am using autofilter to find duplicates then print out sheet, will need to continue printing until condition not found <ActiveSheet.Range("$B$13:B" & Cells(Rows.Count, 3).End(xlUp).Row).AutoFilter Field:=2, Criteria1:="A1" ActiveWindow.SelectedSheets.PrintOut...

Hi, Can anyone help me please how to use/program excel in printing of cheques (checks) in continuous series of check number. Thanks.

I am looking to LOCK the printing activity in the excel UNLESS the user has a password and specific worksheet. I am frustrated and need help. Please. Thank you very much for kindly advise, Rungravee.

I have a workbook that contains numerous worksheets. I want to be able to have a macro that will automatically print every worksheet beyond the specific one when a button is clicked. Is this possible?

Hi Everyone, I have been struggling to resolve an issue for some time. I have data from 3 separate worksheets that I need to streamline a printing process for. I would like to be able to print in some simple way, data from all 3 worksheets and have the end result of 1 page of horizontal data...

Is it possible to dynamically set a print header depending on the page that's being printed? Basically I need to create an attendance tracker that's used by the people inputting the data, and the people tracking it. Each worksheet is assigned to a specific supervisor. The supervisors will print...

Hello, It is my first post here, usually I'm able to sort out my issues with others posts -but this time i'm stuck. I'm just a beginner but trying my best to learn as much as I can. I have recently moved from excel 2010 to 365. I was using macro in "This Workbook" to simply prevent worksheet...

I was wondering if there was a simple macro for printing a selection. I know that this can be done manually by the normal printing process, but I am trying to create a keyboard shortcut to print selection. I am using Excel 365 on a Mac