Skip to content

This site uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our privacy policy to learn more.

Close
AICPA-CIMA
  • AICPA & CIMA:
  • Home
  • CPE & Learning
  • My Account
Journal of Accountancy
  • TECH & AI
    • All articles
    • Artificial Intelligence (AI)
    • Microsoft Excel
    • Information Security & Privacy

    Latest Stories

    • AI-driven spreadsheet tools — what CPAs need to know
    • Is spending on technology spinning out of control?
    • Using 3 Excel View tools to manage large spreadsheets
  • TAX
    • All articles
    • Corporations
    • Employee benefits
    • Individuals
    • IRS procedure

    Latest Stories

    • Social Security Administration head to also serve in new IRS role
    • AICPA calls for fully staffed IRS regardless of shutdown length
    • Job cuts mean strong 2025 tax season may be hard to repeat, IRS watchdog warns
  • PRACTICE MANAGEMENT
    • All articles
    • Diversity, equity & inclusion
    • Human capital
    • Firm operations
    • Practice growth & client service

    Latest Stories

    • Social Security Administration head to also serve in new IRS role
    • AICPA calls for fully staffed IRS regardless of shutdown length
    • PCAOB publishes guidance related to Audit Evidence amendments
  • FINANCIAL REPORTING
    • All articles
    • FASB reporting
    • IFRS
    • Private company reporting
    • SEC compliance and reporting

    Latest Stories

    • SEC accepting Professional Accounting Fellow applications
    • SEC names new chief accountant
    • SEC ends legal defense of its climate rules
  • AUDIT
    • All articles
    • Attestation
    • Audit
    • Compilation and review
    • Peer review
    • Quality Management

    Latest Stories

    • PCAOB publishes guidance related to Audit Evidence amendments
    • AICPA unveils new QM resources to help firms meet Dec. 15 deadline
    • 8 steps to build your firm’s quality management system on time
  • MANAGEMENT ACCOUNTING
    • All articles
    • Business planning
    • Human resources
    • Risk management
    • Strategy

    Latest Stories

    • Business outlook brightens somewhat despite trade, inflation concerns
    • AICPA & CIMA Business Resilience Toolkit — levers for action
    • Economic pessimism grows, but CFOs have strategic responses
  • 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

October 7, 2025

Social Security Administration head to also serve in new IRS role

October 6, 2025

AICPA calls for fully staffed IRS regardless of shutdown length

October 3, 2025

PCAOB publishes guidance related to Audit Evidence amendments

October 2, 2025

Job cuts mean strong 2025 tax season may be hard to repeat, IRS watchdog warns

October 2, 2025

Is spending on technology spinning out of control?

Advertisement

Most Read

Why accountants need to master the art of reading the room
MAP Survey finds CPA firm starting pay on the rise
IRS finalizes regulations for Roth catch-up contributions under SECURE 2.0
Paper tax refund checks on the way out as IRS shifts to electronic payments
IRS shutdown plan: Employees stay on the job for first 5 workdays
Advertisement

Podcast

October 2, 2025

Car talk: M&A, AI and EVs changing the dealership landscape

September 25, 2025

Professional liability risks related to Form 1065, CPA firm acquisitions

September 18, 2025

‘We’re still the thinkers’ — a reminder for tax pros in the AI era

Features

AI-powered hacking in accounting: ‘No one is safe’
AI-powered hacking in accounting: ‘No one is safe’

AI-powered hacking in accounting: ‘No one is safe’

Building a better firm: How to pick the proper technology
Building a better firm: How to pick the proper technology

Building a better firm: How to pick the proper technology

Why accountants need to master the art of reading the room
Why accountants need to master the art of reading the room

Why accountants need to master the art of reading the room

How BI and analytics enhance management accountants’ partnering role
How BI and analytics enhance management accountants’ partnering role

How BI and analytics enhance management accountants’ partnering role

SPONSORED REPORT

Preparing clients for new provisions next tax season

Preparing clients for new provisions next tax season

As the 2025 filing season approaches, H.R. 1 introduces significant tax reforms that CPAs must be prepared to navigate. These legislative changes represent some of the most comprehensive tax updates in recent years, affecting both individual and corporate taxpayers. This report provides in-depth analysis and guidance on H.R. 1.

From The Tax Adviser

September 30, 2025

Current developments in taxation of individuals: Part 1

August 30, 2025

2025 tax software survey

August 30, 2025

Are you doing all you can to keep the cash method for your clients?

July 31, 2025

Current developments in S corporations

MAGAZINE

October 2025

October 2025

October 2025
September 2025

September 2025

September 2025
August 2025

August 2025

August 2025
July 2025

July 2025

July 2025
June 2025

June 2025

June 2025
May 2025

May 2025

May 2025
April 2025

April 2025

April 2025
March 2025

March 2025

March 2025
February 2025

February 2025

February 2025
January 2025

January 2025

January 2025
December 2024

December 2024

December 2024
November 2024

November 2024

November 2024
view all

View All

http://JofA_Default_Mag_cover_small_official_blue

PUSH NOTIFICATIONS

Coming soon: Learn about important news

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

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

Reliable. Resourceful. Respected.