Excel delete all pictures or delete all pictures in specific Cells

Posted on August 23, 2017 by Wyman W

This Excel tutorial explains how to delete all pictures in a worksheet or delete all pictures in specific Cells. Excel delete all pictures When you copy contents from website to Excel, it is unavoidable to also copy unwanted pictures. As some websites contains dozens of pictures, it is a waste of time to delete pictures one by one. In this tutorial, I will demonstrate how to delete all pictures at once. Let's say I want to copy the below table from a website. In the Country of Origin field...

Excel VBA freeze panes using FreezePanes property

Posted on March 12, 2017 by Wyman W

This Excel tutorial explains how to freeze panes in Excel spreadsheet and freeze panes in Excel VBA using FreezePanes property. Freeze Panes in Excel spreadsheet To explain how to freeze panes in Excel VBA, first I have to explain how to freeze panes in Excel spreadsheet. Freeze Row The most common kind of freeze panes is to freeze the first row as it contains the header of the column. So that when you scroll down the spreadsheet, you can still see the header in row 1. Highlight row 2, na...

Excel Descriptive Statistics

Posted on February 28, 2016 by Wyman W

This Excel tutorial explains how to interpret the summary table generated from Excel Descriptive Statistics. Excel Descriptive Statistics One of the options under DATA > Data Analysis is Descriptive Statistics, which generates a statistics summary of a variable. It is very useful because it saves you a lot of time from entering a lot of formulas in order to get some basic analysis. Before using Excel Descriptive Statistics feature, you should first install Analysis Toolpak Add-Ins. As...

Excel find the last row using Worksheet formula

Posted on January 4, 2016 by Wyman W

This Excel tutorial explains how to find last row using Excel worksheet formula. Excel find the last row Finding the last row in Excel is very important especially for creating dynamic data Range, which can be used for setting dynamic Print Area, dynamic Data Validation list, dynamic data source for Pivot Table, etc. When you google this topic, most article talks about how to find the last row using VBA but not the non-VBA solution. In my previous post I have also detailed different way...

Excel dynamic Data Validation list

Posted on January 3, 2016 by Wyman W

This Excel tutorial explains how to create dynamic Data Validation list that automatically adjusts the data Range. You may also want to read: Excel Dynamic Print Area Excel dynamic data range Excel graph dynamic data range Create Excel Data Validation list Excel Data Validation list restricts users to select values from a drop down box. When the input is different from the predefined list, an error message will pop up. Before we create a dynamic Data Validation list, let's brief...

Excel Share Workbook

Posted on January 2, 2016January 9, 2016 by Wyman W

This Excel tutorial explains how to use Share Workbook function to allow multiple users to open the workbook at the same time. Excel Share Workbook Share Workbook function allows multiple users to open the workbook at the same time. Assume that we have a staff list workbook that is placed in the network share drive. Click on REVIEW > Share Workbook Check the box "Allow changes by more than one user at the same time. This also allows workbook merging" &gt...

Excel Compare Worksheets using Compare File

Posted on December 25, 2015May 26, 2016 by Wyman W

This Excel tutorial explains how to compare worksheets using Compare File function. You may also want to read: Excel VBA compare worksheets Excel Compare Worksheets using Compare File Compare worksheets is to compare worksheets of similar structures but different values. Excel has a built it function called Compare File in Office Professional Plus 2013 or Office 365 ProPlus (click here if you are using older version). After comparison is complete, two worksheets are compared side by si...

Excel protect workbook with password

Posted on December 20, 2015December 21, 2015 by Wyman W

This Excel tutorial explains how to protect workbook with password with VBA and without VBA. Different kinds of workbook protection There are several kinds of protection in Excel. Add password to workbook. Users are asked to open the Excel file with password. Protect workbook with password. Protect the structure of all worksheets (do not allow insert, delete, rename, move, copy, hide or unhide worksheets) Hide worksheet with password. Hide the worksheet and add a password to unhide...

Excel add password to workbook

Posted on December 17, 2015March 8, 2016 by Wyman W

This Excel tutorial explains how to add password to workbook with VBA and without VBA. You may also want to read Add password to all Excel workbook in folder Different kinds of workbook protection There are several kinds of protection in Excel. Add password to workbook. Users are asked to open the Excel file with password. Protect workbook with password. Protect the structure of all worksheets (do not allow insert, delete, rename, move, copy, hide or unhide worksheets) Hide w...

Excel add page number in footer

Posted on December 13, 2015 by Wyman W

This Excel tutorial explains how to add page number in footer. E.g. add page number to all worksheets, add page numbers to specific worksheets. Excel add page number in footer to one worksheet Select the worksheet you want to add page number in footer Navigate to PAGE LAYOUT tab > Print Titles Click on Header/Footer tab > select the desired Footer format > OK To check the page number in print preview, Go to FILE > Print Make sure the Settings o...