Question about Microsoft Excel for PC
First go to Sheet4 and in Cell A1 enter:
Then click the cell and hit CTRL+C on your keyboard.
Then select Cells A1 through L10.
When selected, hit CTRL+V on your keyboard
Posted on Oct 19, 2012
I need to sum bad debt in excess of $1000 for Rental & Misc in a single total. Also need to count same.
TYPE Bad Debt LEASE 1,302.89 MISC 1,445.70 RENTAL 86.33 RENTAL 1,372.62 MISC 699.86 LEASE 1,460.93 RENTAL 2,103.75
Can you help with a formula
Posted on Sep 04, 2008
I have 10 rows and 10 columns in my both two exel sheets .i want to fire a query based upon those two base tables and i want to match one base column for that.
Posted on Aug 29, 2008
On sheet 4, select cell A1 and press "=" (don't press enter key).
Select the sheet 1 tab and click on the cell at the top left corner of your sheet 1 data. (dont press enter yet.) Press the "+" sign and then click on the Sheet 2 tab. Select the cell on sheet 2 at the top left corner of the data table on that sheet. Now press "+" again. Now select the sheet 3 tab and select the top left corner of the table there. Finally, press the enter key and you will be back on sheet 4. Cell A1 on sheet 4 will show the sum of the first cells of the tables on sheets 1-3.
Here's how to copy the formula on sheet 4/A1 to the other cells:
Select cells A1:A12 on sheet 4. (in other words, highlight all the cells that will become the top row of the table on sheet 4.) Now press Ctrl-R. This will copy the formula in cell A1 to all the highlighted cells to the Right of it. Finally, highlight the area that will become your table on sheet 4 (12 colums, 10 rows). Press Ctrl-d. This will copy the formulas in the first row Down to all the cells in the highlighted area below.
Posted on Dec 29, 2007
At first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.
If not solved pls get me that data as to reference.
Posted on Dec 04, 2007
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Mar 24, 2011 | Computers & Internet
Mar 20, 2009 | Oracle Database Enterprise Named User Plus
Feb 17, 2009 | Microsoft Excel for PC
Dec 29, 2008 | Reddy Heater-40,000 BTU Kerosene w/T'stat
Dec 28, 2008 | Nintendo Professor Layton & the Curious...
Dec 06, 2008 | Nintendo Professor Layton & the Curious...
Aug 30, 2008 | Microsoft Excel for PC
Jul 08, 2008 | Microsoft Computers & Internet
Feb 03, 2008 | Microsoft Excel for PC
Dec 19, 2007 | Computers & Internet
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
249 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: