Category Expert
Brian I
Avatar Guru
Answers:   83
Points:   442
view profile >
What is Answerbag?

Ask questions and share your knowledge with the world here on Answerbag. Get the best answers where there are no duplicate questions and questions are always open - our community of over 1,142,000 will find your answer!

Join For Free!
Home » Categories » Computers » Software » Spreadsheets
Spreadsheet software

Excel, Lotus, and other spreadsheet software

» Go up to Software
Hide conversational questions
Avatar
Answered
Nov 18 2009
15
Pts
 
 
Rate Question
I have an excel column. Each cell contains a code similar to 16203K - I want to split the cell into 3 seperate columns to seperate the first and last characters - i.e 1 / 6203 / K Is this feasible? I am not technically gifted so simple answer appreciated (3 answers)
by Brian in Microsoft Excel
Avatar
Answered
Nov 15 2009
17
Pts
 
 
Rate Question
If the result of a forumula is zero, I would like for Excel to display a blank cell rather than 0.00. (3 answers)
by Umesh Shah in Microsoft Excel
Avatar
Answered
Sep 1 2009
15
Pts
 
 
Rate Question
In excel how do I change the size of one cell, but keep the rest of the row and column the original size? (4 answers)
by my2cents in Microsoft Excel
Avatar
Answered
Jul 22 2009
15
Pts
 
 
Rate Question
Microsoft Excel 2007 question: How do I associate the first entry in a row with the rest of the row so that it will sort according to the first entry and keep the data in the rest of the row with it? (2 answers)
by Anonymous in Microsoft Excel
Avatar
Answered
Jul 9 2009
20
Pts
 
 
Rate Question
Can I eliminate gaps in a column of data in microsoft excel? (3 answers)
by Cyanotic Wasp in Microsoft Excel
Avatar
Answered
Jul 8 2009
19
Pts
 
 
Rate Question
What is the most exciting formula you use in Excel? (11 answers)
by Anonymous in Microsoft Excel
Avatar
Answered
Jun 21 2009
15
Pts
 
 
Rate Question
What is the most complex EXCEL formula you ever typed? (5 answers)
by LaissezErik in Microsoft Excel
Avatar
Answered
Jun 18 2009
15
Pts
 
 
Rate Question
I have placed an excel workbook as an object within a spreadsheet. I can double-click the object and the workbook pops up in another window allowing me to change data, however no additional columns or rows can be added. How can this be changed? (1 answer)
by Cyanotic Wasp in Microsoft Excel
Avatar
Answered
Apr 10 2009
16
Pts
 
 
Rate Question
EXCEL: How can I sync information typed in one worksheet to a spot on another (within same workbook)? For example if I have to change John Smith's address and he appears on both sheets but in different spots, how can I have this sync automatically? (7 answers)
by mubashiraziz in Microsoft Excel
Avatar
Answered
Apr 9 2009
15
Pts
 
 
Rate Question
What is the Excel VBScript for the following...put a value in cell B1 and a value in cell C1. Then, when I put a value in A1, I need both B1 and C1 to over-write themselves and become the product of A1*B1 and A1*C1. The same for A2,B2,C2 and A3,B3,C3, etc (2 answers)
by mubashiraziz in Microsoft Excel
Avatar
Answered
Apr 5 2009
24
Pts
 
 
Rate Question
Where can i download a tutorial of microsoft excel (7 answers)
by SHAKKY in Microsoft Excel
Avatar
Answered
Jan 13 2009
31
Pts
 
 
Rate Question
WHAT IS EXCEL (2 answers)
by hardrockstar in Microsoft Excel
Avatar
Answered
Oct 7 2008
18
Pts
 
 
Rate Question
On a payroll sheet : A4 = 80 regular hours (max) B4=overtime C4= 110 total hours (A4+B4) How do I make Excel to lock A4 on 80 if A4>80 and put the remaining hours in B4 as Overtime? (3 answers)
by Cyanotic Wasp in Microsoft Excel
Avatar
Answered
Oct 7 2008
20
Pts
 
 
Rate Question
When working in Excel and emailing workbooks, how do you make the files read only - so that any hidden rows or columns aren't able to be pulled up by the recipient? (4 answers)
by Cyanotic Wasp in Microsoft Excel
Avatar
Answered
Aug 16 2008
20
Pts
 
 
Rate Question
Is there any way to force Microsoft Excel to save a particular sheet as a new file, instead of allowing it to overwrite the existing file? Without using "Save As", that is. (6 answers)
by chunz in Microsoft Excel
Get updates when you want them through our RSS Feed! RSS