Make wow look better how to#

(You can do the same for columns, thus seeing the first few column even when scrolling left).Д«onus tip: Use excel tables (new feature in Excel 2007) so that you dont need to freeze panes. It locks the important items on the top so even when you scroll down you still see them. Freeze Panes So that Your boss Knows what she is ReadingДЇreeze panes is a very useful feature. You can use the same trick to lock the charts and other worksheet objects.

To do this follow the steps in the illustration above.

So, it is better to lock the workbook formulas and protect the worksheet so that no one accidentally erase the formulas or mess with them. That is alright if that someone is a CEO of a bailed-out bank, but in all other cases, you end up spending a sweet afternoon trying to figure out what went wrong. You accidentally edit something, say in payroll sparesheet, and you just gave 3200% bonus to someone in the organization. Lock Formula Cells And Protect The WorksheetДЇormulas are the most vulnerable part of an excel sheet. Now right click and select вЂњHideвЂќ option.

Select the first row you dont want to see (45th row) and press CTRL+SHIFT+DOWN ARROW.

Now Right click and select вЂњHideвЂќ option.

Select the first column you dont want to see (24th column) and press CTRL+SHIFT+RIGHT ARROW.

So why show the entire grid when you can, say, just show the 44 rows and 23 columns in which the sales report is presented. Not all spreadsheets have 256 columns and 65000 rows of data. Restrict The Work Area Few Columns and Rows

I suggest using all these tips for a perfect boss proof workbook. So here is the list of 10 tips to make better excel spreadsheets.

Make wow look better how to#

Or, read this post and learn 10 awesome tips on how to boss proof your excel files.

Move to marketing department, you dont need to send excel files any more, just ppts.

Write an unleash_a_pack_of_wild_cats_when_someone_messes_with_the_file () macro: It is not an elegant solution, and cats are not very consistent, but it can work.

There are 3 very easy solutions to prevent this problem, 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.