Skip to content
  • AICPA & CIMA:
  • Home
  • Engage 365 Communities
  • CPE & Learning
  • My Account
Journal of Accountancy
  • TECH & AI
    • All articles
    • Artificial Intelligence (AI)
    • Microsoft Excel
    • Information Security & Privacy

    Latest Stories

    • Tax practitioners need updated AI guidance, council tells IRS
    • What Binance’s $6.3B crypto hack means for CPAs
    • Why AI needs to show its work

  • TAX
    • All articles
    • Corporations
    • Employee benefits
    • Individuals
    • IRS procedure

    Latest Stories

    • Tax practitioners need updated AI guidance, council tells IRS
    • IRS finalizes retirement plan auto-enrollment rules
    • Inflation adjustments to retirement account limits issued for 2027
  • PFP
  • PRACTICE MANAGEMENT
    • All articles
    • Diversity, equity & inclusion
    • Human capital
    • Firm operations
    • Practice growth & client service

    Latest Stories

    • PCAOB proposal would end inspections of some broker-dealer audits
    • Tax practitioners need updated AI guidance, council tells IRS
    • FASAB seeks feedback on its work plan, disposal liabilities guidance
  • FINANCIAL REPORTING
    • All articles
    • FASB reporting
    • IFRS
    • Private company reporting
    • SEC compliance and reporting

    Latest Stories

    • SEC proposes overhaul of executive compensation disclosures
    • SEC proposal aims to clarify securities rules for crypto assets
    • SEC eyes e-delivery as the default over paper
  • AUDIT
    • All articles
    • Attestation
    • Audit
    • Compilation and review
    • Peer review
    • Quality Management

    Latest Stories

    • PCAOB proposal would end inspections of some broker-dealer audits
    • AICPA publishes proposed updates to SOC 2 description criteria
    • PCAOB seeks feedback on comfort-letter proposal, restructures enforcement
  • MANAGEMENT ACCOUNTING
    • All articles
    • Business planning
    • Human resources
    • Risk management
    • Strategy

    Latest Stories

    • 2027 CFO forecast: Mergers and acquisitions on the rise
    • U.S. employee engagement falls below 30% for first time in 15 years
    • Risk response often doesn’t match the threat or the opportunity
  • Home
  • News
  • Magazine
  • Podcast
  • Topics
Advertisement
  1. newsletter
  2. Cpa Insider
CPA INSIDER

4 ways to save time in Excel

Want to be a more efficient — and effective — user of Microsoft’s spreadsheet application? These tips can do the trick.

May 13, 2019

Please note: This item is from our archives and was published in 2019. It is provided for historical reference. The content may be out of date and links may no longer function.

Related

May 1, 2019

A dozen Excel time-savers

March 1, 2019

Microsoft Excel: 10 Excel shortcuts

February 1, 2019

Microsoft Office: Tips for Excel-based financial reports

TOPICS

  • Technology
    • Microsoft Excel
  • Personal Financial Planning

If you are an accountant, you almost certainly use Microsoft Excel.

If you’re like most Excel users, you almost certainly don’t take full advantage of the application’s numerous time-saving features.

That’s OK. Not everybody can be an Excel savant — but almost everybody can get better.

This article features a quartet of Excel tricks to make you more efficient — and effective — with the world’s most popular spreadsheet application. Each tip includes a video walkthrough. You can also download an Excel file with separate worksheets for each trick.    

Note: The content of this article is based on Microsoft Excel 2016 for PCs. Other versions of Excel may work differently. More details on other Excel versions can be found by searching for the version (e.g., “Excel 2010” or “Excel for Office 365”) at support.office.com.

How to quickly foot and cross-foot in Excel

Many accountants consider it good practice to foot and cross-foot a table of values. This means totaling the values of each column (foot) and then verifying the accuracy of those totals by summing together all foots and comparing it to the sum of all rows (cross-foot). Fortunately, Excel can do this in two quick steps.

AutoSum can be used to insert sum formulas that total all columns and rows at the same time. Highlight the data, plus one additional row below and one additional column to the right of the data. On the Home tab, click the AutoSum button, or press Alt + = (equal sign).

Advertisement
ins-1
ins-2
ins-3


Play video walkthrough:


Simultaneously editing multiple worksheets in the same Excel workbook

Flipping between worksheets in an Excel workbook can become tedious and time consuming, especially for tasks such as linking cells from other worksheets. It is faster to have two (or more) versions of the same workbook open. You can do this by clicking View, New Window. Now there will be two versions of the same workbook open, and you can work in different worksheets at the same time. In the illustration below, the income statement balances are being linked to the balances on the year-end worksheet without having to flip back and forth between tabs. Keep in mind, even though you are viewing and working within two or more copies of this workbook, all of your changes are saved in that one workbook.

ins-4

Play video walkthrough:


How to format faster in Excel

Excel has a Format Painter feature that makes it easy to copy the formatting of a cell and “paint” that same formatting on another cell. However, you may not be aware that you can lock that format painter to “paint” that same formatting on as many different cells as you like, as many times as you like.

It’s easy to use. First, apply any formatting to your worksheet. In the example below, a bottom border is being added to cell C9.

ins-5


Next, double-click the Format Painter icon.

ins-6


This will lock the Format Painter, and any cell you click will have that same formatting applied. This can be done to as many cells as you like. In the example below, the bottom border was “painted” to cells B14, B16, C17, C29, C36, C40, and C44 just by clicking those cells.

Advertisement
ins-7


When you are finished, press Esc (escape) and the Format Painter will unlock.

Play video walkthrough:


How to easily calculate end of month in Excel

You can easily calculate the end of the month using the function EOMONTH.

ins-8


For the Start_date, either enter a date or reference the cell that contains the date (J2 in the screenshot above).

For Months, enter the number of months before or after the start date (0 in the screenshot above).

For example, if you would like to have Excel return the end of the same month as the start date, enter 0 for Months. If you would like Excel to enter the end of the next month, enter 1 for Months. If you would like Excel to enter the end of the previous month, enter -1 for Months.

Play video walkthrough:

Advertisement


—
Kelly L. Williams, CPA, Ph.D., MBA, is an assistant professor of accounting in the Jones College of Business at Middle Tennessee State University. To comment on this article or to suggest an idea for another article, contact Jeff Drew, a JofA senior editor, at Jeff.Drew@aicpa-cima.com. 

Advertisement

latest news

November 20, 2026

PCAOB proposal would end inspections of some broker-dealer audits

November 19, 2026

Tax practitioners need updated AI guidance, council tells IRS

November 18, 2026

FASAB seeks feedback on its work plan, disposal liabilities guidance

November 17, 2026

IRS finalizes retirement plan auto-enrollment rules

November 17, 2026

AICPA publishes proposed updates to SOC 2 description criteria

Advertisement

Most Read

IRS announces inflation adjustments for tax year 2027
Inflation adjustments to retirement account limits issued for 2027
How CPAs are putting AI to work in audits
AICPA partners on new offering that assures AI systems and agents
Scary stories of professional liability
Advertisement

Podcast

November 19, 2026

Global tax advocacy, local impact: What the EU omnibus means for U.S. CPAs

November 12, 2026

5 E’s for leading through change in the accounting profession

November 5, 2026

Building a career defined by impact, not accolades or titles

Features

AI raises the stakes for auditor judgment
AI raises the stakes for auditor judgment

AI raises the stakes for auditor judgment

How CPAs are putting AI to work in audits
How CPAs are putting AI to work in audits

How CPAs are putting AI to work in audits

How to craft the CPA career you want
How to craft the CPA career you want

How to craft the CPA career you want

Not-for-profit pay faces broader tax risk
Not-for-profit pay faces broader tax risk

Not-for-profit pay faces broader tax risk

Why AI needs to show its work
Accordance

Why AI needs to show its work

How firms make AI adoption work for them
How firms make AI adoption work for them

How firms make AI adoption work for them

Sales tax doesn’t have to be this hard
Sales tax doesn’t have to be this hard

Sales tax doesn’t have to be this hard

SPONSORED REPORT

Get your clients ready for tax season

Help clients avoid surprises with year-end planning strategies for managing taxable income, maximizing deductions, and adjusting to OBBBA changes affecting individuals and businesses.

From The Tax Adviser

October 31, 2026

AI risks to the Sec. 7525 practitioner privilege

September 30, 2026

Navigating the QSBS rules in pass-through structures

September 30, 2026

Sec. 338(h)(10) elections in business acquisitions

August 31, 2026

2026 tax software survey

MAGAZINE

November 2026

November 2026

November 2026
October 2026

October 2026

October 2026
September 2026

September 2026

September 2026
August 2026

August 2026

August 2026
July 2026

July 2026

July 2026
June 2026

June 2026

June 2026
May 2026

May 2026

May 2026
April 2026

April 2026

April 2026
March 2026

March 2026

March 2026
February 2026

February 2026

February 2026
January 2026

January 2026

January 2026
December 2025

December 2025

December 2025
view all

View All

http://JofA_Default_Mag_cover_small_official_blue

PUSH NOTIFICATIONS

Learn about important news

This quick guide walks you through the process of enabling and troubleshooting push notifications from the JofA on your computer or phone.

CPA LETTER DAILY EMAIL

CPA Letter Logo

Subscribe to the daily CPA Letter

Stay on top of the biggest news affecting the profession every business day. Follow this link to your marketing preferences on aicpa-cima.com to subscribe. If you don't already have an aicpa-cima.com account, create one for free and then navigate to your marketing preferences.

Connect

  • X Logo JofA on X
  • facebook JofA on Facebook

HOME

  • News
  • Monthly issues
  • Podcast
  • A&A Focus
  • PFP Digest
  • Academic Update
  • Topics
  • RSS feed rss feed
  • Site map

ABOUT

  • Contact us
  • Advertise
  • Submit an article
  • Editorial calendar
  • Privacy policy
  • Terms & conditions

SUBSCRIBE

  • Academic Update
  • CPE Express

AICPA & CIMA SITES

  • AICPA-CIMA.com
  • Global Engagement Center
  • Financial Management (FM)
  • The Tax Adviser
  • AICPA Insights
  • Global Career Hub
AICPA & CIMA

© 2026 Association of International Certified Professional Accountants. All rights reserved.

Reliable. Resourceful. Respected.