MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips


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

How to manually change the number grades to letters.

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

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

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

Excel changes entered data to dates automatically!

Can you freeze rows and columns at the same time?

How to round a time value to a specific value.

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

How to use workbook events to enable range selection.

If a control checkbox is not checked then I would like to hide specific rows and columns automatically with VBA.

How to text to columns using VBA.

How to summarize data with pivot table.

How to set cells font with VBA.

How to validate inputbox entry by using macro.

How can I make sure Excel opens my file maximized?

Is there any way I can simply remove certain characters from a text string?

Are there any hotkeys for switching between spreadsheet to spreadsheet?

My colleagues can use the XIRR function, but it does not appear to be available in my version of Excel.

Microsoft is pretty good about making sure that features from one version work in the next version.