Categories
Excel 2013

How to Scale Data for Printing your Excel Worksheet

This article will show you how to fit more of your Excel data onto a page for printing purposes only. It will not affect the size, shape or look of your data in your actual worksheet. Your worksheet will look exactly the same as it always did in your Excel workbook. The only thing that will change is you will be able to print more of your data on one page.

This can be very useful when you are trying to format your workbooks for printing and need a finite amount of data to appear on your printed page.

Follow the steps below to learn how:

  1. Open Excel.
  2. Open the worksheet you would like to print
  3. Click on the Page Layout tab of your Ribbon.

Page Layout

  1. Click the dialog launcher in the Scale to Fit section of the Page Layout tab.

Scale to Fit

  1. Select the Fit to option in the Page Setup menu.
  2. You can choose how many pages you would like to enter the data in here. Make certain you do not put too much content on your page, else it will be too small to read, which does you no good at all.

Page Setup

  1. A good way to fit more data onto your page is to adjust your margins dimensions.
  2. Click on the Margins tab and change the size of your margins for printout.

Margins tab

  1. Click on Print Preview before you print so you can see exactly what your worksheet will look like when printed.

Print Preview

Categories
Subscribers Excel 2013

Subscribers: How to Install a Macro in your Excel 2013 Worksheet

Before we get right down to the nitty gritty, you need to know the different locations where yo might install a macro. You also need to be aware if what you need to make your macro work for you. So, let's start with what you need when creating a macro in Excel. Below is an […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Subscribers Word 2010

Subscribers: How to Rotate a Page of Text in your Document

Ever had a need to rotate the text in your Word document such that it is 90 degrees different than your headers and footers? I will admit that this is not necessary very often, but at times the need does arise. I have covered in past posts that there are ways to do just this […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Subscribers Word 2010

Subscribers: How to Assign a Macro Button to Text In your Documents

I will go out on a limb here and assume that you are already aware that you can only assign a macro to a button on your QAT (Quick Access Toolbar). But did you know that Word will also allow you to add buttons within the text in your documents? Well glory be!  You certainly […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Excel 2013

How to Quickly Copy your Last Action to Multiple Cells in Excel

I am going to go on the assumption that most of you know already that there is a Redo button in Excel and that you can use CTRL + Y to do the same thing that the button does.

But did you also know that CTRL + Y also has an additional function which is to repeat actions as well as redo? Well it does!

  • So if you change the color of your text in cell A2 and want that same thing to occur in cell B3, simply click on B3 and click CTRL + Y.
  • Even better, this doesn’t just work on individual cells. You can use this to repeat formatting on multiple cells simultaneously.
  • Once you format the fill in cell B3 to green, you can now select the cells, C3, C4, and C5 (C5:C7).
  • Click CTRL + Y and the text in those cells will change to green as well.

Ctrl Y

Easy peasy don’t you think?

Categories
Subscribers PowerPoint 2013

Subscribers: How to Set a Embedded Object to Run in your Presentation

Did you know that you can embed an Office file, image, package, or other object into your PowerPoint 2013 file? Well you absolutely can and more than that, you can set it to run as part of your presentation! You also have a choice as to how you run the object,( i.e., clicking it or […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Excel 2010

How to Use Numbers for Column Headings Rather than Letters in Excel 2010

By default, columns are referenced as letters in Excel. It doesn’t have to be that way though!

You can reference your columns by number rather than letter if you so choose.  It’s called an R1C1 style reference and it is more complicated, but it does serve a purpose and has often been needed for complex array formulas within macros in Excel.

Follow the steps below to learn how to change your column headings to numbers:

  1. Click the File tab of your Ribbon and Options.

Options

  1. Click on the Formulas tab.
  2. In the Working with Formulas section, select R1C1 reference style.

Formulas Tab

  1. Click OK and you are finished!
Categories
Excel 2010

How to Turn Off Insert Options in Excel 2010

In Excel there is a feature that will  allow you to modify the way in which you insert rows, columns or cells in your worksheet. When you insert any of these, Excel will display a small, button near the inserted row, column, or cell.

The button,is called called Insert Options and it has a small paintbrush on it, similar to the Format Painter tool. Click the button, and Excel will display options regarding how the row, column, or cell you inserted should be formatted.

Some folks find the Insert Options button distracting, or they never use it. If you are one of those folk, you may want to turn it off.

Follow the steps below to learn how:

  1. Display the Excel Options dialog box:
  2. In Excel 2007 click the Office button and then click Excel Options.
  3. In Excel 2010 display the File tab of your Ribbon and then click Options.
  4. At the left of the dialog box click Advanced.
  5. Scroll through the available options until you see the section named Cut, Copy, and Paste.

Excel Options

  1. Deselect the Show Insert Options Buttons check box.
  2. Click OK.