Direct Technology Group Blog

Direct Technology Group provides professional IT Support and Network Services for Businesses around Deerfield Beach. Computer Services, Tech Support, IT Solutions and more!

Tip of the Week: 4 Tricks to Excel at Excel

Tip of the Week: 4 Tricks to Excel at Excel

When it comes to creating spreadsheets, the go-to option for many businesses is Microsoft Excel. There are a few little-known tricks that can make creating your Excel spreadsheets even faster. For this week’s tip, we’ll go over a few.

Repeat Last Command - If you want to copy the formatting and properties of one cell to another group of cells, you can use F4. Press F4 with the cell that needs the command highlighted. This can help speed up formatting cells to differentiate between the type of information they contain, update the status of certain pieces of information, and so on.

AutoFit Column Width - One of the most irksome tasks when working with Excel is adjusting each column to ensure that all of your data is visible onscreen. Fortunately, there is a solution to this: while the cell with the amount of data you want visible is selected, hold down ALT and press H+O+I. That column will snap to the width needed to display the contents of that cell.

Lock the Format Painter - If you need to reformat a sheet full of data, the Format Painter makes it much easier than selecting and editing each cell, especially if they are all scrambled together and not organized into groups. First, create a cell that is formatted the way you want. With that cell selected, double-click the Format Painter button, found in the Home menu tab. Now the format is locked in, allowing you to add it to any cell that needs it. Once you’ve finished, pressing Esc will deactivate the Format Painter.

Entering Date and Time Information - If your Excel purposes require you to track what time and/or date the information was entered, there are a few shortcuts to assist you with this. Pressing CTRL + ; will put the current date into the selected cell, while CTRL + SHIFT + : will input the current time. You can even put in both by separating the two formulas with a space.

What are your most-used Excel shortcuts? Let us know in the comments!

Simplicity, Flexibility, and More Features: All Go...
Latest Major Retailer Hack: 223 Brooks Brothers St...
 

Comments

No comments made yet. Be the first to submit a comment
Guest
Already Registered? Login Here
Guest
Thursday, 21 November 2024

Captcha Image

Blog Archive

2014
January
February
March
April
May
June
July
August
September
October
November

Mobile? Grab this Article

QR Code
Request a Consultation

Direct Technology Group strives to provide the best comprehensive IT, Computer, and Networking services to small businesses. We can handle all of your organization's technology challenges.

Contact Us
Contact Us

Learn more about what Direct Technology Group can do for your business.

1358 W Newport Center Dr
Deerfield Beach, Florida 33442

Call us: (954) 739-4700

News & Updates
Direct Technology Group is proud to announce the launch of our new website at www.directtechnologygroup.com. The goal of the new website is to make it easier for our existing clients to submit and manage support requests, and provide more information about our services for ...