Change Characters to Superscript

superscript in cell

Do you ever use the Subscript or Superscript fonts formats in Excel? Maybe you’re reporting on chemical usage, and you need to enter CO2 as one of the row headings.

In Word, you can add those commands to the Quick Access Toolbar (QAT). Then, select a character, and click the Superscript command.

Unfortunately, it’s not that easy in Excel – those commands aren’t available when you customize the QAT.

Continue reading Change Characters to Superscript

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

Headers on Excel Combo Boxes

headers on combo box

You can use combo boxes to show a drop down list, either in a UserForm, or on a worksheet. Sometimes a list is easy to understand, like this one, which shows a part number and part name.

If the list has multiple columns, it might help if there is a heading for each column, like the one in the next screen shot.

You could probably figure it out without the headings, but it removes any potential confusion, if you show the labels at the top of the list.

Continue reading Headers on Excel Combo Boxes

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

Excel Images Change Size After Preview

I ran into an odd problem with images in Excel 2010 last week – after looking at the sheet in Preview, a small logo graphic grew big enough to cover the most of the data on the sheet!

Here’s how it looked before the Preview – just a nice, small-sized logo, at the top left of the sheet.

Check the Picture Settings

The first thing I did was check the picture settings – right-click on the picture, and click Size and Properties

Then, in the Properties category, make sure the image is set to “Don’t move or

Continue reading Excel Images Change Size After Preview

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

Problem Breaking Links in Excel

In the screen shot below, there are two files. Cell B4 in the worksheet at the right is linked to cell B7 in the sheet at the left.

In the file with the link, I can go to the Ribbon’s Data tab, and click the Edit Links command,

That opens the Edit Links dialog box, and shows a list of the links in the workbook.

To break the link to the other file, you can click the Break Links button.

When the confirmation message appears, read the dire warnings, and make a backup, if you haven’t already

Continue reading Problem Breaking Links in Excel

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

Calculate Survey Scores with Excel Option Buttons

For easier data entry, you can add Option Buttons on a worksheet. Instead of having to type an answer to a question, just click on one of the buttons, to make a choice.

You can create a simple option group, with only two buttons, like the English or French example shown below.

There are set up instructions in this blog post, and in the video shown at the end of this article.

Create a Survey with Option Buttons

If two options aren’t enough, you can set up something fancier, like Dave Peterson's Excel Survey Template, that

Continue reading Calculate Survey Scores with Excel Option Buttons

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

Click a Check Box to Run a Macro

In the last post, we set up a To Do list with check boxes. Each check box is linked to a cell that’s 2 columns to the right, and we used a macro to set that up quickly.

Today, we’ll create a macro that puts today’s date in the Date column, if you check a box in column B.

Create the Date Macro

The macro will be relatively simple.

We have to figure out where the check box is, when it’s clicked. Then, we’ll find the cell that’s two columns to the right. In that cell, we’ll enter

Continue reading Click a Check Box to Run a Macro

Related Posts Plugin for WordPress, Blogger...

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest