Excel-repeat print area
Results 1 to 4 of 4

Thread: Excel-repeat print area

  1. #1
    Join Date
    Sep 2000
    Location
    Allen, TX, US
    Posts
    306

    Excel-repeat print area

    I have over 200 different Excel files that I need to print only a certain selection of each (the same cells). Is there a way to tell each page to print only that certain space without having to highlight each one and then hit print selection?

    This would save me TONS of time if possible!

    Thanks
    -KZ

  2. #2
    Join Date
    Jan 2000
    Location
    EnZed
    Posts
    2,532
    Hello KZ, yes there is a way, this is exactly the type of job the Excel macro recorder is designed for.
    Step-By-Step:
    • Open one workbook.
    • Before selecting any print areas etc, go Tools>Macro>Record New Macro
    • Give the macro a name (eg: Print_Specific_Area)
    • Change "This workbook" to Personal Macro Workbook in the "store macro in" field.
    • Highlight your cells you want to print in the normal way.
    • Go File/Print/tick the "selection" radio button under "Print What"
    • OK
    • Press the stop recording button on the macro toolbar that appeared when you started recording.

    Now this will be available to you whenever you want to print that area of cells.
    To activate it, go tools/Macro/Macros to see the list of available macros and RUN the selected one.
    You can assign the macro to a customised toolbar button if you like. This is also a relatively simple procedure.
    • Right click a toolbar and select "Customise"
    • Click "commands" tab
    • Scroll down to Macros
    • Click on the smiley face and drag it onto your Standard toolbar
    • Right click on the smiley face and select "Assign Macro"
    • Select the macro you recorded
    • Right Click again and enter a name for the button (will appear in tooltips)
    • Close the customisation box

    You will now have a button to click to print the desired area instantly.

    ------------------
    Sean (Smurfy)
    ....................
    Please remember that others may need to know the outcome of your problem so please keep us updated.
    smurfy
    Linux Counter #318033 Free yourself - Get Linux now
    Running:
    Ubuntu, OpenSuse, Mandriva, FedoraCore, Debian, Slackware and various Windows versions

  3. #3
    Join Date
    Sep 2000
    Location
    Allen, TX, US
    Posts
    306
    Perfect!!

    I'll give that a try and let you know if I have any questions.

    --KZ

  4. #4
    Join Date
    Sep 2000
    Location
    Allen, TX, US
    Posts
    306
    That did the trick. That will save me a lot of time. I hadn't used macros much before, but will now.

    Thanks again.

    --KZ

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •