How to Sum Data in Excel

There are many ways to sum data in an Excel spreadsheet. For example, if you want to sum the values in cells A1:A5, how to do it? 1. Select cells A1:A5, and you will see the sum results in the status bar. 2. Select cells A1:A5, press and hold ALT,…

Formatting a Range of Cells In Excel VBA

Formatting Cells Number General Range(“A1”).NumberFormat = “General” Number Range(“A1”).NumberFormat = “0.00” Currency Range(“A1”).NumberFormat = “$#,##0.00” Accounting Range(“A1”).NumberFormat = “_($* #,##0.00_);_($* (#,##0.00);_($* “”-“”??_);_(@_)” Date Range(“A1”).NumberFormat = “yyyy-mm-dd;@” Time Range(“A1”).NumberFormat = “h:mm:ss AM/PM;@” Percentage Range(“A1”).NumberFormat = “0.00%” Fraction Range(“A1”).NumberFormat = “# ?/?” Scientific Range(“A1”).NumberFormat = “0.00E+00” Text Range(“A1”).NumberFormat = “@” Special Range(“A1”).NumberFormat…

Select a Range In Excel VBA

One of the basic things you need to do in Excel VBA is to select a specific range to do something with it. This article will show you how to use Range, Cells, Offset and Resize to select a range in Excel VBA. Select all the cells of a worksheet…

Highlight the Active Row and Column Use Excel VBA

When you looking at a large worksheet with numerous data, it would be nice if Excel automatically highlighted the active cell row and column so that you can easily read the data to avoid misreading them. See following screenshots: The following VBA code examples show ways to highlight the active…

Zoom In and Out in Worksheet on Double-Click

Sometimes, if you want to zoom in and out in a worksheet, you need to have a finger on CTRL and the other on the mouse, you can scroll the wheel on the mouse while pressing CTRL. Is there a simple way to zoom in and out? here is a…

How to Replace Format in Excel

Sometimes if you need to find and replace cellsĀ formatting in Excel, how could you do? Find and Replace Format in Excel On the Home tab, in the Editing group, click Find & Select button, then click Replace. Or press keyboard shortcut: CTRL+H to open Replace box. Click Options to further…

How To Set Column Width In cm At Once

sometimes if you want to set the column width or row height to centimeters or inches for some purpose, how could you solve this problem? Set the column width to centimeters Click View tab, in Workbook Views group, click Page Layout button. To change the column width, do one of…

How to Copy as Picture include Row and Column Headings

Sometimes, if you want to talk about Excel formulas with your colleagues, you must want to give your colleagues complete information by including row and column headings in your figures. Here’s how to copy Excel selection as picture include row and column headings. For Excel 2003 Click File, Page Setup….