formulas

Episode 341 – Printing Row Numbers

               

How to print your worksheet with the row and column headings visible. Episode 341 shows you how to make your printout look just like your Excel screen, plus two reasons why you would want to do this. Learn how to print formulas instead of values and how to print your cell comments at the bottom(…)

Episode 159 – Get characters up to the Dash

               

Episode 159 – Get characters up to the DashThe Left, Mid, Right functions are great, but what if you need to grab a variable number of characters from the left portion of the cell? For example, you need all of the characters up until the first dash? In this case, you will have to use(…)

Learn Excel from MrExcel