EXCEL: Quickly Filling in Cells in A Table

3 Comments

It is very annoying when a table has blank cells.  You can not filter, sort or even produce accurate pivot table or graphs.  The solution is to manually fill in the cells.  Here is a way to eliminate this tedious process.

Fill in empty cells

 

Notice that the cells are blank under each state. You need to fill in these cells in order to work with tables.

  1. Highlight the cells from the bottom up by using the Control and Mouse (this is the sparatic selection).
  2. The last cell that is chosen and active should be B4.
  3. OR click on Find & Select, Go To Special, BlanksFill in empty cells highlightedpng
  4. Type = and click on B3
  5. Control EnterFill in empty cells highlighted and completed

There You Have it!

EXCEL: Quick Way to Repeat Text in Cells Without Autofill

1 Comment

An acquaintance of mine showed me a way to repeat text without using the autofill.  Here is a simple way to do it:

  1. Highlight several cells
  2. Type in the text in the active cell
  3. Click on Control+Enter key

There you have it!

WORD: Repeat Table Headings at the Top of Every Page

Leave a comment

When you create a lengthy table that continues on more than one page, Word doesn’t display the table’s headings (i.e., the table’s first row) at the top of each page that contains a portion of the table. This can make multi-page tables hard to read. However, you can easily configure Word to repeat a table’s heading row wherever the table breaks across pages.

If you’d like to use just the first row of your table as a repeated heading:
1. Place the insertion point anywhere within the table’s first row or select more than one row.
2. Choose Table | Heading Rows Repeat from the menu bar.
**When you do, Word automatically repeats the selected row contents wherever the table breaks across pages. In addition, Word automatically adjusts the placement of repeated heading rows so that when you add or remove rows from the body of the table, the repeated heading rows always appear at the top of the page.

Word DOES NOT display the repeated row headings when Normal, Outline or Web Layout view is active. They are still applied when the print coomand is issued.

WORD: Positioning Drawing Objects Using the Grid Lines

Leave a comment

Here is a simply way to place drawing objects in just the right location eliminating approximation,or the guesssing game.

To create a grid in your document:

  1. Select Draw | Grid from the Drawing toolbar.
  2. In the Drawing Grid dialog box, select the Display Gridlines On Screen check box and click OK.

Customize your gridlines
You can choose how far apart to space your gridlines, and you can choose to remove the vertical lines if you’d like.

To adjust your gridline spacing:

  1. Select Draw | Grid from the Drawing toolbar.
  2. In the Grid Settings area, increase or decrease the numbers in the Horizontal Spacing and Vertical Spacing spin boxes. Smaller numbers create closely spaced gridlines, and larger numbers widen the gaps between gridlines.

To remove the vertical gridlines:

  1. Select Draw | Grid from the Drawing toolbar.
  2. Deselect the Vertical Every check box in the Grid Origin area of the Drawing Grid dialog box. Click OK.

Another Method for 200, 2010, and 2013
Change your grid settings by going to the Page Layout tab and in the Arrange group, click the Align button and choose Grid Settings from the resulting dropdown list. This choice opens the Drawing Grid dialog box. You can also quickly hide/show your gridlines by selecting or deselecting View Gridlines from the same dropdown list.

 

EXCEL: Recovering Unsaved Workbooks (2010)

Leave a comment

What if you forget to save a workbook, or accidentally saved it when you should have saved it as a different name, or maybe you lose work because of that rare power outage? There’s no need to panic when you think you’ve lost your work in Excel 2010. You can quickly and easily recover older (unsaved) versions of your workbook.

Excel 2010 saves your unsaved versions of files in a specific folder on your hard drive.

Remember that these are new, unsaved files or temporary files, such as those you might open from an email or file transfer. Here’s how you can recover one of these unsaved files.

To recover an unsaved version of a file:

  1. Open Excel 2010 and click on the File tab.
  2. Click Recent on the left, and then click the Recover Unsaved Workbooks button.
  3. In the Open dialog box, you’ll see the contents of your UnsavedFiles folder. For Windows Vista/7, this location is: C:\Users\User_Name\AppData\Local \Microsoft\Office\UnsavedFiles. For Windows XP, the location is: C:\Documents and Settings\User_Name \LocalSettings\Application Data\Microsoft\Office\UnsavedFiles.

Note that the files saved in your UnsavedFiles folder will no longer be available after four days from the file’s creation or modification.

EXCEL: 11 very useful excel keyboard shortcuts

Leave a comment

11 very useful excel keyboard shortcuts

EXCEL: Double Click Tricks

Leave a comment

  1. Double Click on the XL logo on the very top left corner to Close Excel.
  2. Adjust column widths by selecting multiple columns and double clicking on the separators (the thin line between the column letters).  This method also works for the rows.
  3. Auto-fill a series of cells with data or formulas using the double-click. Lets say you have a table where in one column you have some data and in the next you have written a formula in the first row. Simply, select the one cell then double click on the autofill box which can be found at the bottom right corner of the cell.  The mouse converts to a skinny black cross. The trick works for formulas, auto-fills (of numbers, dates, what not) as long as the adjacent column has data.
  4. Jump to last row/column in table with double-click. Just select any cell in the table and double click on the cell-border in the direction you want to go.
  5. Lock a particular feature and reuse them with double-click. You can lock any repeatable feature (like format painter, drawing connectors, shapes etc.) by just double clicking on the icon (in Excel 2007 this works for format painter, but for drawing shapes you need to right click and select lock drawing mode). This can save you a ton of time when you need to repeat same action several times.

Older Entries

Follow

Get every new post delivered to your Inbox.

Join 504 other followers