How To Search An Excel Spreadsheet

We all know that we can search in MS Excel by using CTRL + F to display the Find tab of the Find and Replace dialog box and do a search of the entire worksheet.

If you want to place a limit on your search, however, there is another way to do this. Follow the steps below:

Select the range you want to search before you press CTRL + F.

Perhaps you only want to search a specific column in your worksheet.

Selecting that column before displaying the Find tab of the Find and Replace dialog box will perform the search only in that range of cells, ignoring the rest.

To find out more about Excel Training Perth

How to hide the contents of a cell in Excel

Here is another pretty nifty tip that you can use in MS Excel – have you ever had occasion to want to hide the contents of a cell from a reader that is not privy to certain information? Of course you have! Haven’t we all? The good news is that you can and it is pretty easy to do.

Follow the steps below:

1. Select the cell in your spreadsheet.

2. Click on Format | Cells.

3. Click on Category | Custom.

4. Enter three semicolons in the Type box.

5. Click OK.

Those values will not be visible on-screen unless you highlight that cell. If you should highlight that cell, you will still be able to view the values on the formula bar, but not on-screen.

To find out more about Excel Training Perth

How to change the colour of the tabs in Excel

Were you aware that you can color the tabs in your MS Excel spreadsheets? Well you can and it can be pretty helpful too when you are trying to draw a user’s attention to those little tabs at the bottom of your spreadsheet!

Follow the steps below:

1. Right-click the tab.

2. Select Tab Color.

3. Select the color you would like to use.

How to resize a column in Excel

To resize a column:

Move cursor to the edge of the column to resize, on the column letter eg: C. When you see a double pointed arrow, just double click. The column width will increase to fit the longest text in that column.

How to quickly return to the top of an Excel spreadsheet

To return to cell A1 from anywhere on your worksheet, press CTRL key and HOME key together.

To jump to the bottom of a very long column, simply select a cell in the column and double-click the top or bottom edge of the cell.

To return to the top of your data, click the edge of the cell. Clicking the left or right edge of the cell works in the same manner for going across rows.

How to Calculate the time between two dates in Excel

To calculate days between 2 dates:

Enter the dates in separate cells. Then in a blank cell enter a formula to subtract one date from the other. Endure that the cell containing the formula is formatted to number. For example, enter today’s date and your date of birth to see how many days you have been on this planet!

How to link headers across multiple sheets in Excel

To put a header eg: Company name on many multiple sheets in a workbook, type the name in a cell on the first sheet. On subsequent sheets, place a cursor in an empty cell.

Enter = (equal sign) and then click on the name in the first sheet. Press Enter. Repeat on as sheets as required. In this way, if you need to change the name, you only do it once.

You can do the same for addresses, phone numbers etc.

Benefits of Customised Business Solutions:

Benefits of Customised Business Solutions:

• Flexibility
• Use a solution to match your business needs
• Stay ahead of your competition
• Increase your Company Value
• Provide better service to your customers
• Protect your software investment from becoming obsolete
• All applications are developed in Microsoft Office Professional
• Share all data with your Team
• Use data from your Accounting System, where possible
• Store your data in a structured and useful manner
• Make training easier for your new staff

Contact us to see how we can assist your business and staff.

“Let us Help You Build a Better Business By Mastering Your Computer Hardware and Software”

“Let us Help You Build a Better Business By Mastering Your Computer Hardware and Software”

PerthSoftware.com are award winning Specialists, with over 22 years expertise, in Custom Computer Software Application Development, Programming and Training with Microsoft MS Access Database, MS Excel Spreadsheet, MS Outlook & MS Project.