Spreadsheet is from column A to S. How do I print it on two A3 pages so it is readable?
SOURCE: excel
If you remember the password, then all you need to do is select tools, unprotect worksheet and enter password
SOURCE: I need a running balance in a column for a petty cash spreadsheet
Hi,
for Column E, if current cell is E(x) and previous cell is E(x-1) then,
formula will be:
=E(x-1) + C(x) - D(x)
logic: C is added to last balance, D is substracted the same way
Hope this helps.
SOURCE: When I try to merge my excel document with 250
Hi deloisr
It looks like you have chosen the wrong data file. Probably an earlier version of your data still present in some folder.
Check these
Do you have column headings for every column?
Make sure which folder contain the file? What exactly is the name?
When you are in the Microsoft word, make sure you select the correct data file for your mail merge. If you have selected the correct data file, when you attempt to insert the merge fields, there is no way, it give wrong field names.
The only reason you get the erong field names is because you have the wrong excel file for your data. Fix this problem first, then the rest will sort themselves out.
Have a good day.
luciana44
Testimonial: "At first I dismissed this assessment but when I checked my document I found the advice was correct, my problem is solved. Thank you. "
SOURCE: setup multiple spreadsheet pages
Do you mean to display multiple sheets at the same time? Please check out the solution provided below (this applies to Excel 2003)
1.) To view multiple sheets in the active workbook, click New Window on the Window menu. Switch to the new window, and then click a sheet you want to view. Repeat for each sheet you want to view.
2.) On the Window menu, click Arrange.
3.) Under Arrange, click the option you want.
To view sheets in only the active workbook, select the Windows of active workbook check box.
SOURCE: when i open an excel spreadsheet, the columns go right to left instead of left to right.
Testimonial: "This works for the spreadsheet I open, but how do I make this a fixed feature, so every time I open a spreadsheet, it reads left to right?"
Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.
Click on the "Insert" tab at the top of the document.
Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.
Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.
Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.
Hit the "OK" button at the bottom of the Create Table dialog box to create your table.
46 views
Usually answered in minutes!
×