Adjusting Row Appearance in Excel 2007

Just as you may modify the column appearance in Excel, the program also provides tools for adjusting row appearance in Excel 2007. Certain data - like text - may take up significantly more room than simple numeric entries do. In such a case, you may find that adjusting row appearance provides a more optimal viewing experience.

To adjust row height using the mouse, simply position your mouse cursor over the bottom border of the numbered row you want to adjust. Your cursor will change. Click the mouse and drag the row to the height you wish to use. Excel will indicate the point value (and pixel value) of the row. Selecting multiple rows will enable to you to change all selected rows at one time.

To specify a precise row height, select one cell in the row or rows you want to change. Select Home > Format > Height. Type in the new row height in points. Click OK. All selected rows will reflect your change.

Excel also provides an Auto Fit feature for adjusting row appearance in Excel 2007. To use it, click the header of the row you wish to adjust. Select Home > Format > Auto Fit. Excel will automatically optimize row height to accommodate the data in the row. Excel will return you to the active worksheet.

You may also apply appearance changes to non-adjacent rows within Excel. To select non-adjacent rows, press the Alt key and click each row you wish to alter. Drag one row to the desired height with the mouse or access the Row Height dialog box as described earlier. Enter your changes and click OK. All selected non-adjacent rows will be changed.

In addition, you may use the formatting buttons in the Alignment section of the Home tab to change the appearance of data within a row. Wrap Text, Merge Cells and Orientation are the only formatting controls that can affect the height of a row automatically when they are applied.

Hiding Columns in Excel 2007

When working with data sheets, you may create figures that are sensitive, or that make the worksheet look messy. Hiding columns in Excel 2007 is an easy way to clean up messy calculations, or protect sensitive data from public view. Hiding columns doesn't change or eliminate the data; they are still present. They are simply not displayed.

To hide a column in Excel 2007, select the entire column. Select Home > Format > Hide & Unhide > Hide Columns. The selected column is hidden, and you are returned to the active worksheet. Effectively, this action sets the column width to 0. You may also hide a column using the Home > Format > Width command. In the dialog box, set the column width to 0. Your column will be hidden.

You may hide multiple columns simultaneously by selecting all columns to be hidden and using the Hide Columns dialog box, or the Width command to set the selected columns' widths to zero. The columns you select can be adjacent or non-adjacent.

Excel provides a keyboard shortcut for hiding columns. Select a cell in the column you wish to hide. Press Ctrl + 0. The column will be hidden. Alternately, you can select the column header. Right-click to activate the contextual menu and select "Hide." The column will be hidden.

Excel will not display the column header for hidden columns, but you may still refer to hidden columns in formula. Searches will still be performed on hidden columns as well.

To unhide a column, select at least one cell on both the left and right of the hidden column(s). Select Home > Format > Hide & Unhide > Unhide Columns. Your hidden column(s) will reappear.

Excel also provides a similar keyboard shortcut to unhide columns. Select at least one cell on either side of the hidden column(s). Press Ctrl + ) to unhide the column(s). Alternately, you may right-click your selection and choose "Unhide" from the contextual menu.

Hiding Rows in Excel 2007

Just as when you are working with columns, certain row-based calculations or data groups may make your worksheet look messy. Hiding rows in Excel 2007 will improve or simplify the appearance of a worksheet, or protect sensitive data from public view. Hiding rows in Excel 2007 doesn't change or eliminate the data; they are still present. They are simply not displayed.

To hide a row in Excel 2007, select a cell in the row you wish to hide. Select Home > Format > Hide & Unhide > Hide Rows. The selected row is hidden, and you are returned to the active worksheet. By hiding a row, you have set the row height to 0. You may also hide a row using the Home > Format > Height command. In the dialog box, set the row height to 0 points. Your row will be hidden.

You may hide multiple rows simultaneously by selecting all rows to be hidden and using the Hide Rows dialog box, or the Height command to set the selected rows' heights to zero. The rows you select can be adjacent or non-adjacent.

Excel provides a keyboard shortcut for hiding rows. Select a cell in the row you wish to hide. Press Ctrl + 9. The row will be hidden. Alternately, you can select the row header. Right-click to activate the contextual menu and select "Hide." The row will be hidden.

Excel will not display the row header for hidden rows, but you may still refer to hidden rows in formula and search hidden rows for matching data.

To unhide a row, select at least one cell in the rows above and below the hidden row(s). Select Home > Format > Hide & Unhide > UnhideRows. Your hidden row(s) will reappear.

Excel also provides a similar keyboard shortcut to unhide rows. Select at least one cell above and below the hidden row(s). Press Ctrl + ( to unhide the row(s). Alternately, you may right-click your selection and choose "Unhide" from the contextual menu.

Headers and Footers in Word 2007

In Microsoft Word 2007, a header is a section of the document that appears at the top of each page, computer desk manufacturer above the first line of text. A footer is the section that appears between the last line of text and the bottom of each page. Headers and footers can be customized to contain graphics and text that improve the look and readability of the document. In the default setting, the contents of headers and footers in Word 2007 appear on every page of the document.

By default, each document in Word is created with an empty header and footer. To add content to headers and footers in Word 2007, simply select Insert > Header > Edit Header or Insert > Footer > Edit Footer. The main portion of the document will be grayed out, and the header or footer will become active. Enter whatever type you wish. If your content exceeds the space allotted for the header or footer, Word will simply expand the size of the header/footer to accommodate your content. Increasing the header or footer will decrease the size of the regular document space.

You may insert type, graphics, a field, or pre-defined information, such as the current date and time, or the page number. These special elements can be found under Design > Quick Parts. From this point, you'll be able to select Date & Time, Field or Page Numbers. You may also choose Property to insert one of the document properties, like author, comments, status, subject or title. To add a picture or clip art, select Design > Picture or Design > Clip Art and browse to find the file you want to insert. You can resize pictures or artwork to suit your needs.

For the first page of a document or section, you may not want the document header or footer to appear. To suppress the header and/or footer on the first page, select Design > Different First Page. You'll notice that the header and footer labels have changed to L & U shape computer desk,metal computer desk,office desk indicate that this is the first page. Adjust the first page header and footer to your satisfaction.

If you use Word 2007 to create a document with facing pages - such as those found in reports and books - select Design > Different Odd & Even Pages. Create the appropriate header and footer for each page. Closing the header or footer will reactivate the main document.

Internet Viruses Can Target Your Computer

No matter who you talk to, everyone has either had a computer virus or knows of someone who has gone through the agony of trying to get rid of the problem. Computer viruses are a hot topic that seem to affect everyone who owns a computer system, whether at work or at home.

The companies that produce software programs that catch and delete these computer viruses are constantly updating their databases for virus types and definitions so that they can better protect your system against all the newest viruses. Creating virus protection programs is a multi-billion dollar business that is growing more and more everyday.

The number of viruses being created and uploaded to the Internet is growing at an astounding rate of a new computer cart desk one every eighteen seconds! This definitely keeps the virus protection companies on their toes with research and development.

Because these viruses copy themselves to any computer system they come in contact with, the spread of viruses throughout a computer network or the Internet is a very fast and deadly thing to happen to your computer. Because computer viruses are a hot topic, they routinely are the subject of magazine articles and forum topics online. While some viruses do nothing more than frustrate you with pop-up ads or other messages, others are completely malicious and set out from the start to destroy the files and operating systems of your computer.

Of the 53,000 viruses that have been identified and classed, more than 80 percent of them have been classed as malicious and capable of harming your computer system or data files. These computer viruses behave in much the same way as biological viruses by contaminating any computer systems they come in contact with. These self-executing programs are generally very small and work at damaging the way your computer works or by damaging or completely removing key system files.

When computer viruses are a hot topic, more and more people find out about the destructive power of these programs. In this way a great many people find out about virus protection programs and rush out to get the newest protection programs or they ensure that their computer virus protection is up to date. Many magazine and news articles about computer viruses have the effect of sometimes panicking people into believing that their computers are at risk. Having a good anti-virus program and current updates is one of the best ways to protect your computer system against virus attacks.

This must also be coupled with good file habits such as scanning all downloaded files with the anti-virus program before opening them. It is always a good idea to take the time to ensure that the file you thought you were downloading is indeed the file you have. For instance, a file that labels itself as a movie file and is less than one megabyte in size is not a movie file. Movie files are generally nearly a thousand times that size and therefore, the file you have downloaded is most likely not a movie file and may in fact be a computer virus.

Computer viruses are a hot topic at the office when a virus attack manages to get past protection protocols put in place by the network administrators. All it takes is one person allowing some executable files they have been sent to open and start replicating itself through the network of computers to make life Hell for that company. Virus attacks can cripple office systems very quickly resulting in lost revenue and consumer confidence which can affect the way that stocks in that company are traded resulting in even further financial losses. That is why it is so important for larger businesses to have comprehensive computer virus protection programs in place.

These virus programs are much more detailed and powerful than the anti-virus programs that many consumers have protecting their computer systems. Because the fallout from a virus attack is much more financially damaging to a large corporation, the virus protection program needs to be much more robust and capable of protecting multiple systems within the corporation. Computer viruses are a hot topic among businesses simply because of the way that they can affect the company financially.