How to Hide Worksheet Tabs in Excel Workbook
Excel trick to prevent users from un-hiding “hidden sheets” in an excel file.
Sales Funnel Charts in Excel – Tutorial
Sales funnel is a very common business chart. Here is a simple bar chart based trick you can use to generate a good funnel chart to be included in that project report.
Automatically insert timestamps in excel sheet using formulas
Often when you use excel to track a particular item (like expenses, exercise schedules, investments) you usually enter the current date (and time). This is nothing but timestamping. Once the item is time stamped, it is much more easier to analyze it. Here is an excel formula trick to generate timestamps.
Excel Basics – What are Combination Charts and How to Make One?
A combination chart is when you combine two different charts to make one. A popular example for combination chart is a line & bar graph combination.
Selecting all the cells in a series – keyboard and mouse shortcuts [spreadcheats]
Here is a very quick spreadcheat for the new year.
If you need to select all the cells in a series (either row-wise or or in columns) you can use one of these 2 shortcuts (and avoid unnecessary scrolling)
1. Select the first cell in the series
2. Press Shift + Ctrl + Down arrow
Or
1. Select the first cell in the series
2. Hold down SHIFT and Double click on the edge of cell in the direction you want to select
Use Alt+Enter to get multiple lines in a cell [spreadcheats]
A very quick spreadcheat for Friday. If you need to type content in a cell and you want to see it multiple lines then use alt + enter to break the content in several lines. See to the right for an example.
Bonus tip: If you are using formulas to create content in a cell by combining various text values and you want to introduce line breaks at certain points … For eg. you are creating an address field by combining house number, street name, city and zip code and you want to introduce line breaks after house number and street name then you can use CHAR(10).
Custom Views in Excel – Save filter and header settings for quick reference
PHD reader and commenter Vishy contributed this post through e-mail. Thank you so much Vishy for this very useful tip. The Problem: You have created a specific view of your data in Excel (say by filtering, zooming out, changing column width, hiding specific rows, customizing window settings, print settings etc.). This is your reference point […]