MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips

Unmerge Cells Easily »

February 22, 2002

I tried to remove the check mark from the "Merge Cells" box but the option was unavailable.

How to Create Top List »

February 21, 2002

Need a formula to add the 9 highest valued cells out of 11 cells.

Changing Grade Numbers to Letters »

February 20, 2002

How to manually change the number grades to letters.

Excel Data Map »

February 19, 2002

Have you ever tried the data map application in Excel?

Working with Time Formats »

February 19, 2002

I would like to know how I could actually remove the colon from the time value without it turning to decimal.

Insert Image into Worksheet Footer »

February 18, 2002

How to insert logo into Excel as a footer to appear on every sheet.

How to Filter Out Duplicate Data »

February 17, 2002

I work closely with comparative lists and need to learn how to either identify duplicate cells or even better filter out duplicates.

Keeping Excel from Changing Data to Dates »

February 16, 2002

Excel changes entered data to dates automatically!

Freeze Panes for Select Rows and Columns »

February 15, 2002

Can you freeze rows and columns at the same time?

Rounding Time to a Specific Value »

February 14, 2002

How to round a time value to a specific value.

Use MsgBox to Execute Optional User Choice »

February 13, 2002

I would like something which the user gets asked a question and yes leads to macro and no does nothing.

Excel Copy Subtotals »

February 12, 2002

How to copy only the subtotal rows to a new Excel range.