Converting multiple text numbers into real numbers or reversing the sign on multiple numbers is easy in Excel if you know how to use Paste Special.
Monthly Archives: September 2017
“The better the questions you ask yourself, the better the outcomes will be #questionsrule”
@ExcelYourself
2017-09-24
2017-09-24
Hyperlink to a Range in Excel
Select a range with a click
Hyperlinks are a great way to navigate around complex spreadsheets. Most times when you create a hyperlink you link to a single cell within the sheet. In some cases there is a good reason to link to a range.
Inserting a Blank Row Between Entries in Excel
A sorting solution
Over the years I have had many requests to help people insert blank rows between entries is a list. Apparently there is an import routine that requires it. My normal solution is a macro because it automates the whole process but there is a manual technique that is quick and easy.
Avoid Overwriting Files in Excel
A reason to open as read-only
Why would you purposely open a file as read-only? If you regularly open files from last month and then save them as this months’ version then read-only is your friend – see how.