XL-ian

Microsoft Excel Consultant

 

Enter More than one line of Data in a Cell


Entering more than one line of text in a cell is as simple as pressing Alt+Enter to make a new line inside the cell. if you don't want line breaks, you can have multiple lines in a given cell by clicking cells from the Format menu. Click on the Alignment tab and enable Wrap Text. Entering data wider than the column width will then wrap on the next line.

 

Protect Cells From Data Entry


Keeping certain cells in Excel spreadsheets from being modified is easy. Select the cells you wish to allow writing to. Non-adjacent cells can be selected by clicking on them while keeping the Ctrl key pressed. After selecting the cells, click Format > Cells. Under the Protection tab, uncheck the Locked checkbox and click OK. Next, click on Tools > Protection and select protect Sheet. You will be prompted for a password that is optional. Click OK and save the spreadsheet. Now only the unlocked cells and be modified. Trying to overwrite locked cells result in an alert message being displayed. If you want to protect only a few cells, it would be good idea to select the entire worksheet and use the Ctrl key to deselect only the cells you want to protect before unlocking them.

 

Give your Worksheet a Background


Add a background image to your spreadsheet. click on Format > Sheet > Background. Browse for the image you want and click Open to select it. The given image will tile to fit the worksheet.

 

Make a quick graph/chart

Enter the following in a spreadsheet:

  A B
1 DATA  
2 100  
3 300  
4 650  
5 425  
6 175  
7    
8    
9    
10    

Highlight A1 to A6 and press F11