University at Albany, State University of New York
Contact UAlbany Directories Calendars & Schedules Visitors Site Index Search
Admissions Academics Research IT Services Libraries Athletics
State Accounting Homepage
News
Staff
Authorized Signatures
AP-102 Form
Travel
General Travel Procedures
Travel Reimbursement
Travel Advance
State Contracted Agencies
Interviewee Travel Costs
Citibank Travel Account
Procedures Manual
Introduction
Receiving and Payment
IFR Billing and Collections
Account Management
Accounting Reports
Procurement Card
Introduction
NYS PROCUREMENT CARD APPLICATION
                    
All Funds Reporting
Forms
Links


Sponsored Funds Financial Management
(formerly known as Sponsored Funds Accounting)

State Accounting
 
Accounting |Authorized Signatures | Optimizing Authorized Signature Lists

Optimizing Authorized Signature Lists

Some of the functions in Microsoft Excel can assist in optimizing usage of the Authorized Signature Lists. Information is available about increasing column widths and searching the list.


Increasing Column Widths

Example of a cell whose text exceeds the column width

However, the width of a column can be increased. Select the cell whose width should be increased. From the Format menu, select Column and then select Width:

A window will appear which allows you to set the width of the column. Type the new width and click okay.

Set new column width

For this example, the width was changed to 20. Now, the entire cell can be read.


Searching

Microsoft Excel has the ability to search for text within a spreadsheet in order to quickly locate information. From the Edit menu, select Find. In the Find window, type the text you would like to locate:

Find window

You will then be taken directly to the appropriate cell.

Search results


Top