YOU Magazine - May 2022 - 4 Best Spreadsheet Hacks You Need To Know
Follow Me On:          
Subscribe to YOU Magazine and other timely market alerts from Rick R. Johnson.

YOU Magazine
Rick R. Johnson     Rick R. Johnson
Cert. Mort. Advisor/Mort. Broker/Solution Expert
Village Financial Group, Inc.
Phone: 916-367-3738
Fax: (916) 295-1451
License: NMLS #360614, CalBRE# 01711076
Rick@RJ4Loans.com
www.RJ4Loans.com
Village Financial Group, Inc.
May 2022



April 2022
March 2022
February 2022
January 2022
December 2021
November 2021


    
4 Best Spreadsheet Hacks You Need To Know

4 Best Spreadsheet Hacks You Need To Know

If you're someone who works with large amounts of data, it might be overwhelming to try to keep track of everything. That's where spreadsheets come into play. One of the most popular and universal tools is Microsoft Excel, which recently celebrated its 35th birthday.

No matter if you're a beginner or an advanced user of spreadsheets, you can benefit by learning more about four Excel spreadsheet hacks.

Select all cells. If you need to reformat your font or make a sweeping change, you might already know you can click Ctrl + A, but you can also click on the square in the upper left-hand corner to select all the cells. It will also select all the empty cells.

Shift between different cell files. When you have different spreadsheets open, you might find it frustrating to move from one to the other, especially if working on the wrong file can ruin everything. Use Ctrl + Tab to freely shift between different files.

Add a diagonal line to a cell. If your file has an address list, you might benefit from using diagonals to separate different attributes between rows and columns. Click on Home, Font, and Borders. In Borders, you'll find More Borders, which gives you an option to make a diagonal line.

Use a single quote mark to signal zero. When you have an input that starts with zero, Excel will delete the zero by default. You can easily fix this problem by placing a single quotation mark ahead of the zero.

Excel is a helpful tool that allows you to compile information in an organized fashion. Becoming familiar with some Excel tips can help you quickly analyze information and be more productive.

Sources: Analyticsvvidhya.com, Lifehack.org, Quickbooks.intuit.com




You are receiving a complimentary subscription to YOU Magazine as a result of your ongoing business relationship with Rick R. Johnson. While beneficial to a wide audience, this information is also commercial in nature and it may contain advertising materials.

INVITE A FRIEND to receive YOU Magazine. Please feel free to invite your friends and colleagues to subscribe.

SUBSCRIBE to YOU Magazine. If you received this message from a friend, you can subscribe online.

UNSUBSCRIBE: If you would like to stop receiving emails from Rick R. Johnson, you can easily unsubscribe.

Village Financial Group, Inc.
1212 Suncast Lane, Suite 1
El Dorado Hills, CA 95762

Powered by Platinum Marketing

© Copyright 2024. Vantage Production, LLC.