Last week I wasted an entire afternoon because of an errant bug in my Excel that prohibited me from being able to use Excel's Paste Special dialog. … [Read more...]
Search Results for: excel
How To Create Internal Links in Excel
It's safe to assume most people know how to create links in Excel that point to Web pages. Personally, I prefer to use the shortcut Ctr-K (Mac: … [Read more...]
Auto Increment Lists By Dragging In Excel
One nice option you have in Excel is the ability to drag series values down, saving you the time of entering individual values for well-known lists. … [Read more...]
Change Dashes To Zeroes In Excel
I might be alone in this, but I hate seeing hyphens in lieu of 0's in tables and charts. Here's what it looks like: To change these … [Read more...]
How To Convert Google Analytics’ Funky Month of Year Format In Excel
UPDATE: Since I've had a couple questions about how to display the date as just the month and year, I created a Google Sheet demonstrating several … [Read more...]
- « Previous Page
- 1
- …
- 12
- 13
- 14
- 15
- 16
- …
- 31
- Next Page »