Excel Topics

Hide / Show Worksheet Gridlines

March 14, 2017 0

The gridlines displayed in a worksheet can be very useful especially when you are designing your worksheets. There are times however when you may want to hide the gridlines. How to hide/show gridlines for a […]

Tricks & Tips

Using AutoCorrect For Shorthand Data Entry

January 3, 2017 0

You can use the AutoCorrect feature to create shortcuts for commonly used words or phrases. For example if you find yourself regularly typing a company name e.g. MasterExcel.net you can create an AutoCorrect entry for […]

Tricks & Tips

Fill Blank Cells in a Row or Column

October 2, 2016 0

00In this example we have a table of data listing each persons sales per quarter. What we want to do is add text “NO NAME” to¬†the rows that no longer contain a name in column […]

Excel Topics

Quick Analysis Tool

September 18, 2016 0

The Quick Analysis Tool brings the most commonly used formatting, charting and summary tools into one convenient location. The tool allows you to quickly create an Excel table or Pivot Table, create a new chart, […]

Tricks & Tips

Enter Today’s Date

August 2, 2016 0

Probably the most common date you will enter in Excel is the current date. A quick and simple way to avoid having to type the same date again and again is to use the keyboard […]

Tricks & Tips

Display Day Name From A Date

February 23, 2016 0

If you need to get the day name (Monday, Tuesday, Wednesday etc.) from a date there are several options depending on your needs. In this article we will show you a few examples on how […]

Tricks & Tips

Delete Row if Cell is Blank

November 26, 2015 0

In this example we have a table of data listing each persons sales per quarter. What we want to do is delete the rows that no longer contain a name in column A without having […]

Tricks & Tips

Automatically SUM() with ALT + =

July 26, 2015 0

Quickly SUM an entire row or column by clicking in the first empty cell in the column or row. Use the shortcut keys ALT + = Excel will guess the range you want to sum. […]

Tricks & Tips

Name Ranges using “Create from Selection”

July 25, 2015 0

Named ranges can be used to make it easier to navigate large worksheets¬†but can also be used in formulas instead of typing or pointing to specific cells. In this example we will demonstrate how to […]

Tricks & Tips

Remove All Data After /

May 17, 2015 0

Question: I have list of domains in excel I would like to delete all the subfolders without going in one by one is there a way to do? example: www.domain.com/subfoldername www.domain2.com/subfoldername my list has about […]