Excel4Business - Our Blog

Excel Tips and Tricks from our Experts

Our Blog - By Top Excel Consultants

Excel Help - How to Hide and Unhide Rows and Columns in Excel

In this video you’ll learn how to hide rows and columns in Excel and then display them when you need them. Hiding and unhiding are useful functions when you would like to hide certain information for displaying or printing and then restore it when necessary.

Start by selecting the rows or columns that you would like to hide.

Go to the Home tab, find the Cells group, and click Format.

Find Visibility, select Hide & Unhide, and click Hide Rows or Hide Columns.

To display a hidden row, select the row above and below the row or rows that you would like to unhide.

If you want to display a hidden column, select a column to the right or left to the column or columns that you want to unhide.

Go back to the Home tab, find the Cells group, click Format, select Visibility, choose Hide & Unhide, and click Unhide Rows or Unhide Columns.

Posted by Mila Hadzhiracheva on Mon, 11 Jan 2016

Excel Help - How to Move Columns in Excel 2013

In this video you’ll learn how to drag, move and swap columns in Excel. You’ll find this useful if you have several columns and would like to switch their locations according to relevance.

To begin with, click on a column heading to select it.
Right-click and select Cut.
Right-click the cell before which you would like the cut cell to appear and select Insert Cut Cells.
The new column will appear to the right of the one you selected.
Alternatively, you can select the cell you want to cut.
To do this, go to the Home tab, Select Clipboard, click on Cut to and click Paste.
If you have an Excel table, you can move columns more easily by dragging and dropping the columns within the table.
Simply select the column you want to move, move the mouse pointer to the border of the selected column until it turns into a four-sided arrow,
and drag the column to a new location.

Posted by Mila Hadzhiracheva on Mon, 11 Jan 2016

Excel Help - How to Switch Columns and Rows in Excel 2013

This video will show you how rearrange your data from rows to columns and vice versa. In Excel, switching rows and columns is called “transposing”. If you entered your data in rows and want to move it to columns instead for better display or vice versa, you can do this quickly and easily with the “transpose” function.

This video starts by rearranging data from rows to columns.
To do this, select the cells in the rows that contain the data.
Right click and click Copy.
Now choose the location of the new columns and select the first cell in the destination columns.
Right-click and click Paste Special.
Select the Transpose checkbox.
Click OK.
The steps are the same for moving data from columns to rows.
Select the column.
Right click and click Copy.
Now choose the location of the new columns and select the first cell in the destination columns.
Right-click and click Paste Special.
Select the Transpose checkbox.
Click OK.

Posted by Mila Hadzhiracheva on Fri, 8 Jan 2016

Excel Help - How to Create Drop-down Lists in Excel 2013

In this video you’ll learn how to create a drop-down list in Excel. This is very useful if you are conducting a survey or asking other users closed type questions. You can simply list the values you want them to choose from and let them select the one which applies from your list. Drop-down lists will also save you time if you’re manually entering data into an Excel table that can only take a certain value, such as yes and no, parent or guardian, etc.

Open your worksheet and type the question or source data.
Now enter the options you want to see in your drop-down list.
Go back to the first sheet and select the cell where you would like the drop-down list to appear.
Go to the Data tab in the ribbon.
Click on Data Validation.
Go to Allow.
Select List.
Go to Source.
Type in the values you want to appear in the list separated by commas.
Click OK.
Take a look at the drop-down list and make sure it works.

Posted by Mila Hadzhiracheva on Fri, 8 Jan 2016

Excel Help - How to Set a Print Area in Excel 2013

In this video you’ll learn how to select and print only part of your Excel worksheet. Setting a print area is useful when you have a large table of data or any other type of content and only want to print part of it.

To begin with, select the table or the cell range you would like to print.
Go to the Page Layout tab. Click Print Area. Click Set print area. Click Save.
To check if you successfully set the print area,
Go to Print and select Print Preview.
You can also see the cell addresses selected and change them from the Page Setup menu.
Click the small arrow in the bottom right of the Page Setup section.
Select ‘Sheet’ and you’ll see the Print Area expressed as a range (A1:C3).
You can use this selection tool which will allow you to re-select a new print area.
Just type in the names of the cells in the range.

Posted by Mila Hadzhiracheva on Fri, 8 Jan 2016