Using Text to Columns to Convert Text to Dates
Summary: Working with dates requires those dates to be in an Excel Date format. Here is how to convert a text date to one of the many Excel date formats:
- Select the range of text dates.
- Click the Data tab.
- Select Data Tools | Text to Columns and a wizard dialog box will open.
- In the wizard dialog box, click Next twice to go to Step 3 of the Wizard.
- Use the default settings in the first two steps of the wizard.
- In Step 3 of the wizard, select the Date option and select your desired format.
- Click Finish and the text dates will convert to dates that can be formatted and used in calculations.
Selecting only Visible Cells in a Worksheet
Back to top
Summary: There are times when you want to only copy the visible data in a worksheet. Here is how to do this:
An example of this is when you need to copy SubTotals that have hidden rows and columns. A normal copy and paste will include the hidden data.
Here's the steps:
- Select the range of cells.
- From the Home tab, in the Editing group, select Find & Select.
- Under Select, select Visible cells only.
- Select OK.
- On the Home tab, in the Clipboard group, select Copy.
- Activate the worksheet you want to copy the data to.
- On the Home tab, in the Clipboard group, select Paste.
Just the visible cells will be pasted in the worksheet.
Creating a Text Box
Summary: There are times when you want to add a note to a cell. It is easy to do this with a Text Box. Here is how to do this:
- On the Insert Ribbon select Text Box.
- Draw a rectangle in your worksheet about the size and shape that you want your text to fill.
- Paste or type in you text.Select the text in the text box and use the Mini Toolbar to format the text to an appropriate font size.
- Right click in the text box and select Format Shape.
- On the Line Color category, select No Line. In the Text Box category you, you can specify the number of columns you would like in the Text Box.
Highlighting Information in a Word Document Using Shading
Summary: There are times when you would like to highlight a piece of text in your Word document. Here is how to do this:
You can do this with Word's shading tool.
- To add shading to a paragraph involves the following steps:Click and place your insertion point in the paragraph that you want to shade.
- Click on the Home tab of the ribbon.
- In the Paragraph group, click on the down-arrow to the right of the Shading tool. (This tool looks like a tilted paint bucket, spilling paint to the right.) Word then displays a shading palette.
- Hover over a color and your paragraph will be shaded with that color.
When you find a colour that you like, click on the colour and your paragraph will be shaded.