Do You Excel at Excel? — Ten Steps To Help You Do So.

Microsoft ExcelIf you aren’t using Excel you’re missing out one of the most versatile applications in the Microsoft Office Suite.  You can use Excel spreadsheets to simplify an extensive variety of tasks —To organize, plan, calculate, and more.

Specialists with an in-depth knowledge of Excel use it to develop customized proposals, contracts and other documents.  Artists even use Excel to produce digital art.

In addition, Excel spreadsheets can be used in conjunction with programs like Access. Excel possesses many capabilities that aren’t apparent to most users.

The following are some tips that can save you time, and help you use Excel.

1.  Easily jump to the start or end of a column.

If you are deep into a spreadsheet, and you want to move to the first or last cell of a column, use CTRL + ↑ to jump to the top cell, or CTRL + ↓ to drop to the last cell.

2.  SUM() with ALT + =

  • This function adds a column or row of numbers.  Simply click in the first empty cell of a column.
  • After this, enter ALT + = (equals key) to add the numbers in every cell above.

3.  Adjust The Width of One or More Columns

Click on the column’s header, —Move your cursor to the right side of the header, and “double click” when you see the + sign.

4.  Add To, or Delete Columns 

Managing columns and rows can be a tedious task. You can save time by using CTRL + ‘-‘ (minus key).  This deletes the column, and CTRL + SHIFT + ‘=’ (equal key) adds a new column.

5.  Display Formulas with CTRL + `

When troubleshooting, display the formula in a cell by using Ctrl + ` ( ` is furthest to the left on the row with the number keys).

6.  Format Numbers

To format a number as currency, use CRTL + SHIFT + 4 (+4 is the same at the $ symbol). Do the same when formatting a number as a percent, — use CRTL + SHIFT+ 5 (+5 is the % symbol).

7.  Move Between Worksheets

To jump to a worksheet, on the right enter CTRL + PGDN.  Conversely, enter CTRL + PGUP  to move to the worksheet to the left.

8.  Replicate a Formula in Multiple Cells

You can easily reproduce the same formula again and again, and populate all of the cells in a column with the same formula while adjusting them to use the data specific to each row.

Simply create the formula in the first cell. Then move your cursor to the lower right corner of that cell and, when it turns into a + sign, “double-click” to copy the same formula into the remaining cells in that column. The cells in the column will exhibit the results of the formula using the data in that row.

9.  Reproduce Patterns and Dates

You can do this by entering information in two rows to establish a pattern.  Simply highlight these rows and drag down the cells to populate rows. This works with any symbol or items displayed in the cells.

10.  Copy a Format Into Multiple Cells

Simply “double click” Format Painter. This tool lets you duplicate a format in other cells. You can also use use this feature to copy the format into multiple cells.

For more information about Excel, and how you can use it to save time and improve your day-to-day efficiencies, contact LAN Infotech at (954) 717-1990, or email us at:

Fort Lauderdale Computer Networks
Network Services in Fort Lauderdale
Network Consulting in Fort Lauderdale
Fort Lauderdale Data Backup
Data Security Fort Lauderdale
Client Feedback

“We are a loyal LAN Infotech client and have had the pleasure of working with them on a major network infrastructure project. We find their network engineers to be knowledgeable regarding the latest hardware and software solutions. LAN Infotech is especially strong when it comes to network security issues.”

—Lisa Carman
Office Administrator
Siegfried, Rivera, Lerner, De La Torre & Sobel, P.A.
read more»

Featured IT Services Fort Lauderdale Articles

LAN Infotech Recognized as Leading Microsoft Marketing Partner Worldwide

The team of IT specialists from LAN Infotech are thrilled to announce that they have been recognized on Fifty-Five and Five’s Inbound Marketing Excellence Report as one of the top 250 Microsoft mark

Read more

Featured IT Services

IT Consulting Advice for Fort Lauderdale: Taking Care of Your Employees Is Taking Care of Your Business!

Quid Pro Quo An IT consulting firm in Fort Lauderdale will usually advise that you get what you give. This is the core principle which defines most working relationships. The employer gives the em

Read more

Featured IT Services

IT Services Business Advice: Do You Really Need a Management Consultant in Fort Lauderdale?

Eliminate the Middleman IT services in Fort Lauderdale need not cost an arm and a leg to provide services your own organization could source internally. You want a consultation agency willing to he

Read more

Featured IT Services