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.

Page Borders in Word 2007

Microsoft Word 2007 offers some limited page layout capabilities. One such feature enables you to add a border around text or other page contents. Page borders in Word 2007 can add a decorative touch to a document and can be applied to each page in a section or the entire document, or to a single page within the document.

Word 2007 comes with a selection of page borders, including plain, dashed, dotted and decorative lines, artwork and three-dimensional shadowed lines. The artwork within the program is appropriate for certain celebrations and events, such as birthday and holiday parties, common announcements and seasons of the year.

To add page borders in Word 2007, select the page or section to which the border will be applied. Choose Page Layout > computer cart desk Page Borders. The Borders and Shading dialog box will appear. From within the Borders and Shading dialog box, select the basic border type - Box, Shadow, 3-D or Custom.

Within the same dialog box, choose the border width, style and color. The default border is a solid line, but you may choose a different line style or to substitute artwork for a plain line. You'll find dozens of pre-loaded page borders in Word 2007. There is no way to add custom border artwork, however. Select the appropriate border from the list of those available.

You can control which sides of the page the border appears on. To add or delete a border, simply click on each line along the side of the page graphic shown in the Preview section of the dialog box.

From the "Apply to" list, indicate whether the border should be applied to each page in the document, the current section, the first page of the current section or all pages except the first page of the current section. Click OK to apply the border.

Windows Cannot Find File at Startup - How to Solve This Error Message?

If you already have the problem with "Windows cannot find Somefile.exe. Make sure you typed the name correctly, and then try again.", be sure that you have thousands of "colleagues" all over the world. The visible part of the problem in most cases is that you see "Windows cannot find" error message on your Windows startup. If you see "Windows not found" error for the first time, think of which third-party program could show it. In most cases "Windows not found" error message means that there was a command to run some file, but the file itself is absent. As a rule "Windows can't find" error message means that you have a virus infection on your computer.

Be sure to check your computer with the latest version of your anti virus if you see "Windows conference table,laptop stand,printer equipment table,trainning table cannot find XXX. Make sure you typed the name correctly, and then try again." on Windows startup. If "Windows can't find" error is caused by some malicious program, it is often accompanied by other problems like performance loss, poor Internet connection or additional error messages. No matter how this problem came to your computer, the only definite thing is that you will have to solve it sooner or later. When your computer boots, Windows reads a list of files that should be started automatically, and the program causing "Windows cannot find Somefile.exe. Make sure you typed the name correctly, and then try again." can appear among them. Let God bless you if you want to try solving "Windows cannot find XXX. Make sure you typed the name correctly, and then try again." problem manually.

We also faced with situations when "Windows cannot find" was caused by the second part of autorun entry, especially if the first part of it was connected with Rundll32.exe file. To summarize all discussed above: there are several tens of possible (and different!) reasons how "Windows not found" error message could appear on your computer. Recently installed program can cause "Windows could not find" problem as well. The other most important source of this problem is YOU who deleted some important system file thinking that it is not useful. If you are professional, you will certainly need to use "Autoruns" program, as it provides much more options for editing your autoruns list than any other program of this kind.

If you are an experienced user and want to seach your autorun list and fix "Windows not found" error - use msconfig.exe utility shipped with your Windows. You may also try to use System Restore to restore your Windows to the state where there was no "Windows can't find" problem at all, but this helps only in one case from ten. For safer fixing of "Windows not found" error we recommend you to reboot into Safe Mode. Fixing "Windows could not find" problem manually can be a tedious task if you are professional and dangerous task if you are newbie. Never commit your friends to solve your computer problems, especially with "Windows cannot find" if you are not sure if they are known the exact solution.

Great Plains Installation - Overview For IT Professional

Microsoft Dynamics GP installing process is straight forward and simple if your company deploys versions 10.0 or 9.0. If you are still on earlier version or on Pervasive SQL or Ctree: 7.5, 7.0, 6.0, 5.5 or 5.0 - then installation requires either to be done by professional consultant or GP support person should be available on the phone during installation phase. Version 8.0 is also relatively simple, however we heard some complains on ODBC connection creation. Let's review installation phases:

1. New Server Installation. This is when you are coming through implementation process. It is very unlikely that you do it in-house - GP requires professional consultant for initial installation, data conversion and implementation

2. Moving GP Server from one computer to another. There is special technical article on Microsoft customer source website to do so. If you are experienced SQL DBA, then all what this article does is transferring SQL logins and DB security for GP databases - this should be good hint for DBA folks

3. GP user workstation installation. Insert GP CD#1 and follow installation wizard. Versions 9.0 and 10.0 will create ODBC DSN for you automatically, so if you are reading wizard questions - you should be fine. Earlier versions require ODBC manual creation - please read installation manual

4. Customization Installation. If you have add-ons or customizations (typically written in GP Dexterity and distributed as Dex chunk), be sure to copy the chunks into GP user workstation directory

5. Reports Dictionary location. If you are installing GP in mid-size or large organization, the chances are high that you are sharing REPORTS.DIC. Prior to install new GP workstation, please review Dynamics.set file for working users. This setup file should give you the idea where shared dictionary is located and how to modify Dynamics.set file on new workstation

6. FRX. FRx financial reports: Balance Sheet, P&L, Cash Flow, including reporting trees and consolidated reports should be installed with special attention to ODBC settings for the company and SYSDATA folder location. Please review the settings for existing and working FRx workstations first

7. Crystal Reports. If you have them, then installation is simple - just install computer workstation,computer carrel,audio visual cart & stand Crystal Reports designer and then instruct user how to open reports from your network shared folder

8. Integration Manager and eConnect integration connectors. If you are also installing IM tool, then know that for version 10.0 you have a set of eConnect conectors, requiring you to specify domain name and userid for eConnect user. eConnect gives you the option to speed up integration, however it requires you to specify DB name in integration, meaning that you eConnect integration will work for just one company only. This is not really a big constraint as you can always copy integrations and have them tuned to work with your multiple companies as required.

Effective Use of Spreadsheets - Microsoft Excel - Indexing Your Spreadsheets

Almost everyone these days use spreadsheet in their daily life, whether it is at work or at home or at school.

However, many are also just using it for its basic function, without knowing or exploring other functions and features that are available in spreadsheets, like Microsoft Excel.

Some are too afraid to ask others as they may look stupid for not knowing.

Others may want to read up on the additional functions and features, but the amount of books available and the thickness of these books tend to scare them away.

What I will do in this series of tips on "Effective use of spreadsheets" I will explain useful features in Microsoft Excel, which would make working with spreadsheets easier, whether you use spreadsheets for serious applications in the office or to catalogue your DVD collection or to keep your favourite recipes.

One feature that I have found to be very useful, especially if you have a large number of spreadsheets to work on or refer to frequently, is Indexing Your Spreadsheets by using the HYPERLINK Function.

When you have 10 or 50 or 100 spreadsheet in your workbook, you may find locating a particular spreadsheet by scrolling through the sheet tab at the bottom of the spreadsheet as being very difficult and time consuming.

The best way to locate find fast and accurately is to create your Spreadsheet Number 1 as an INDEX SPREADSHEET for the whole Workbook.

Try this out.

1) Open a New Spreadsheet File

2) On Row 1 Column A (location A1) type in Customer A or Recipe A

3) Right click on A1 and scroll down to HYPERLINK and click on it

4) Select Place in this document on the left hand side

5) Select Sheet 2 from the list - Cell Reference

6) Press OK

You have now referenced Cell A1 in Sheet 1 to Cell A1 in Sheet 2

You should now see Customer A in Cell A1 Sheet 1 with a Hyperlink underline to it.

When you place your cursor over A1 in Sheet 1 and click there, it will take you straight to Sheet 2

7) Now do the same on Cell A1 in Sheet 2 but now reference to Sheet 1 to take you back to Sheet 1 (the Index)

Repeat Steps 1 to 7 for a few more spreadsheets, say about 5 or 6 more, for Customer or Recipe B onwards, and then see the results.

Great isn't it.

Now you have just created a link through an Index Spreadsheet and a link to go back to the Index in every Spreadsheet.

Have fun trying it out and using it EFFECTIVELY in your daily work.