1 :: In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format?
In the date field properties of the table, form, or properties manually input the format you would like. It is not required to choose one of the date formats in the drop down box. Example would be mm/dd/yyyy.
|
2 :: How do I put password to protect my entire Spreadsheet so data cannot be changed?
1. Click Tools2. Scroll down to Protection, then Protect Sheet
3. Enter a password, Click OK
4. Re-enter password,
Click OK
|
3 :: What is Freeze Panes and how do I do it?
1. Row - Select the row below where you want the split to appear2. Column - Select the column to the right of where you want the split to appear
3. Go to the Menu Bar
4. Click Windows
and then click Freeze Panes
|
4 :: How do I Format data in MS Excel?
1. Must Always highlight the data before formatting2. Click Format
3. Then go to Cells
|
5 :: How do I resize Columns and Rows to better fit the data in MS Excel?
1. Move the mouse in between any two labels (Rows/numbers or Columns/letters)2. The pointer will turn into a vertical (letters) or horizontal (numbers) line with arrows on both ends
3. Simply drag the column or row to the desired size
|
Home 
Webmaster Said:
Thank you.
khwazak Said:
best regards
rajiv Said:
ABHINAI VATS Said:
debraj Said:
dipankar.mco@rediffmail Said:
surabhi saraf Said: