All articles with 'freeze panes' Tag

10 Tips to Make Better and Boss-proof Excel Spreadsheets

Published on Nov 3, 2009 in Excel Howtos, Featured, Learn Excel
10 Tips to Make Better and Boss-proof Excel Spreadsheets

We all have atleast one story of how that one time the boss / co-worker / classmate / cat ruined the carefully crafted excel spreadsheet by mucking up the formulas or disturbing the formatting. Read this post to learn 10 awesome excel tips to make better and boss-proof excel sheets.

Continue »

Do you know these Double-click Tricks in Excel?

Published on Jun 12, 2009 in Excel Howtos, Featured, Learn Excel
Do you know these Double-click Tricks in Excel?

Most of us think of mastering formulas, learning macros and being supergood with charts when we think of being productive with spreadsheets. But often learning simple stuff like keyboard shortcuts, using mouse and working with menus and ribbons can be a huge productivity booster for us. So as part of this installment of spreadcheats we […]

Continue »

Prevent users from scrolling away on your dashboards [dirty little trick]

Published on Nov 25, 2008 in Charts and Graphs, Learn Excel

Dashboards let users get all the information they want in a quick glance. Not if users start using scroll bars and scroll down to cell A64000. So here is a quick and dirty trick. Assuming your dashboard ends in row 40, select row 41 and go to menu > window > freeze panes. That way […]

Continue »

Excel can be Exciting – 15 fun things you can do with your spreadsheet in less than 5 seconds

Published on Aug 1, 2008 in All Time Hits, Featured, hacks, ideas, Learn Excel
Excel can be Exciting – 15 fun things you can do with your spreadsheet in less than 5 seconds

Who said Excel takes lot of time / steps do something? Here is a list of 15 incredibly fun things you can do to your spreadsheets and each takes no more than 5 seconds to do. Happy Friday 🙂 1. Change the shape / color of cell comments Just select the cell comment, go to […]

Continue »