Blog
customer center

410.616.2000

rss Google Plus linkedin twitter facebook

Ready to Eliminate IT Stress?


computers

Next Level Technology Blog

Next Level Technology has been serving the Hunt Valley area since 1997, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: 3 Better Ways To Use Excel

Tip of the Week: 3 Better Ways To Use Excel

Microsoft Excel is more or less synonymous with spreadsheet creation. However, even power users may not know all the tricks that are hidden in the program that can help them save significant time. For this week’s tip, we’ll go over some Excel shortcuts that you may not have known about.

Adding the Same Text to Multiple Cells
It’s a hassle that every Excel user has faced: the same text needs to be inserted into many cells. Fortunately, there’s a simpler way to go about doing this than one cell at a time. If you highlight the cells that need the text entered before typing the text, and press Ctrl and Enter instead of just Enter, your selected cells will have that text added in.

Auto-Sum Shortcut
Excel can naturally be used as a quick-adding calculator, but a quick shortcut can make that easier. Highlighting the cells, you need to add together before pressing Alt and = will give you final sum.

Data Sorting, Made Easier
In those cases where you need your data to be sorted by a particular variable, Microsoft gives you the means to do so in their Auto Filter. Once your spreadsheet is populated with your data, you can select the columns to be filtered by selecting the top rows. Once you’ve done so, click Data. You will then see options for Filter and subsequently, Auto Filter. This adds a drop-down menu to each column, allowing you to sort the entire spreadsheet by that data in that column.

What are your most-used Excel shortcuts? Tell us in the comments, and check back in to the Next Level Technology blog for more useful tips.

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Saturday, 19 August 2017
If you'd like to register, please fill in the username, password and name fields.

Captcha Image

The Next Level Technology Way

  • Expert Team of IT Specialists
  • Best IT Tools - optimized
  • Support Process provides outstanding service

Mobile? Grab this Article!

Qr Code

Download Our Free Managed IT eBook

free whitepaper image

Learn 10 distinct benefits Maryland Small Businesses gain from taking a managed approach to their IT.

Proudly Serving These Areas

Anne Arundel County: Annapolis, Crofton, Edgewater, Glen Burnie, Highland Beach, Jessup, Linthicum, Odenton, Parole, Pasadena, Severn, Severna Park, and more

Baltimore County: Baltimore City, Catonsville, Cockeysville, Dundalk, Essex, Gwynn Oak, Hunt Valley, Owings Mills, Pikesville, Randallstown, Towson, White Marsh

Carroll County: Eldersburg, Finksburg, Hampstead, Marriottsville, Westminster, and more

Harford County: Bel Air, Edgewood, Havre de Grace, Joppa, and more

Howard County: Clarksville, Columbia, Elkridge, Ellicott City, Hanover, Laurel, Lisbon, and more