cell

While doing some research for a reader's recent query regarding automatic recalculation in the MS Excel Status Bar, not only did I find an answer for the reader, I also found an alternative method of watching the recalculation without using the ... Status Bar in MS Excel 2007. Turns out you can take a picture link of a cell and place that picture link any place you like in your Workbook. When the cell changes, it will show the change in the picture link. You can use either of the two methods below: You can use the Paste Picture Link command after copying the cell of interest You can scroll ... (view more)

This is one of those little tips that most folks aren't aware of but are ever so grateful for the knowledge once they have learned it. Why? Because it saves time and keystrokes, of course! 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. In a nanosecond you will be at the bottom of the data in that column, regardless of whether it's 12,000 rows long! 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. Now ... (view more)

Folks who do not use MS Word tables all the time often become frustrated because they are stymied as to how to resize one cell without changing all the other cells in their table. You know the drill -- you need a large cell for Names and a small ... cell for a numerical list but every time you change one cell, the rest follow suit in the other rows! It is really a very simply process once you know how: Select the cell you would like to resize. Position your mouse on the border of that cell. Now drag your cell border either right or left until it is the desired size you want. To be even more ... (view more)

Ever gotten your table just perfect? Everything is just the way you like it, cell height is perfect and you have text wrap working, every other row is highlighted...then you decide you would like to save it but you have it all full of data! Rest ... easy, this is a no-brainer and can be done with ease!Just select your entire table and depress the Delete key -- that's it! All the text and data is gone and you are left with your perfectly formatted table. Note: Do not use your backspace key as that will delete your entire table. Now that you have that perfect table saved you can use it for any ... (view more)

Sometimes within your worksheet, you may have different, non-standard numbers. Perhaps you have dates and times and currency numbers. If you want MS Excel 2007 to interpret these different, non-standard numbers the way that you do, you will need to ... format the number properties in the cell in which they appear. Follow the steps below to change the number formatting of a cell in MS Excel 2007: On the Home tab of the Ribbon, find the Number group. In the Number group, there are various different options you can use to quickly format the numbers in your selected cells. The first option you will ... (view more)

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: ... Right-click the tab. Select Tab Color. Select the color you would like to use. 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 ... (view more)

At times, it can be a real problem when an URL is entered into a cell and MS Excel automatically creates a clickable hyperlink. There may be times when you would like to disable that particular feature. Preventing the automatic creation of ... hyperlinks can be accomplished by three different methods. Follow the steps below to learn how:From version 2000 forward, the automatic creation of hyperlinks can be disabled by reconfiguring the AutoCorrect settings by following these steps: Click on Tools | AutoCorrect. Click the AutoFormat As You Type tab. Under Replace As You Type, uncheck Internet And ... (view more)

Most of you are familiar with the AutoSum feature in MS Excel and find it very handy indeed. All you have to do is click that icon on your toolbar and bingo! your formula for the sum of a data range is located just above whatever cell you have ... selected. I know that there are lots of folks out there like me who prefer to use the keyboard as much as they can because we like fewer keystrokes and saving time! So if you are one of those folks, here is another quick and easy way to sum in MS Excel.Select the cell below your column of data Then simply click ALT + = (Alt, plus the equal sign). Ta-da ... (view more)

A reader recently inquired: "I have a table and would like to color the entire background of a single cell in the table. I am able to color the text in the cell, but not the entire background of the cell. I use MS Office 2003. Any suggestions are ... much appreciated." My reply: Place your cursor in the cell in which you would like to have shading. Now click on Format | Borders and Shading. Click on the Shading tab. On the left side, under Fill, select the color you would like to use. On the right side, under Apply to, use the drop-down arrow and select Cell. Click on OK. That's really all there ... (view more)

When you move around in your worksheet, you most likely use the arrow keys or the Page Up and Page Down keys. Those keys get the job done, but you are selecting a different cell as you move around. To find out how to scroll and keep the current cell ... selected, follow the steps below: Press the Scroll Lock key Use the arrow or Page Up/Down keys. When you are finished, be sure to press the Scroll Lock key again to toggle this functionality off. Follow these steps to quickly return to your original cell: Use the Edit | Go To command (or Ctrl + G). Choose the Special button (or Alt + S), then ... (view more)