Fonts Too Small or Eyes Too Big?
replies , 1/12/2006, 6:16:39 AM
Can someone tell me how I can get the fonts on the bottom tabs on worksheets, the defining tabs I can change the colors and names and everything but enlarge. Also is there a way to keep what you...
replies , 3/20/2006, 9:30:22 PM
To all experts, Please could you help me i have a list of people( more than 1 entry for the same person) in column a and and a number in column b i can get excel to do the subtotal function i...
Excel and launching userforms
replies , 8/20/2006, 1:07:02 AM
Greetings, I want to do something that I hope is not too unusual. i want to test a value in a cell, and if it one thing or another... launch a user form. Here is the scenario... test cell a1, if...
Stopping spreadsheet save
replies , 9/14/2006, 2:47:43 PM
Hi We have a spreadsheet that we share among users by keeping it on a shared location on server. The problem is that we want everyone to be able to modify the sheet but we want to stop users...
DATE IN TEXT FORM - NEED TO CHANGE IT DATE FORM
replies , 10/27/2006, 3:50:14 PM
Hello! When I download data into excel some of the dates in the data comes as: 2Sep'06=20 I edit the cell by taking out the apostrophe and the value becomes a = date. What formula /...
SUM PRODUCT & CUMMULATIVE BALANCE
replies , 10/27/2006, 4:43:10 PM
Hello! I am able to use SUMPRODUCT to sum amounts based on dates as shown = below: =3DSUMPRODUCT((sheet2!$C$2:$C$1000=3DC1)*(sheet2!$E$2:$E$1000)) Column C have the dates and Column E have the...
Rename name so formulas show name change
replies , 11/3/2006, 6:52:38 PM
Excel 2003 Cell A1 is named MyCell. Cell A2 has formula "=MyCell". I rename cell A1 in the toolbar to NewCell. Cell A2 still has the formula "=MyCell". How do I rename cell A1 to NewCell and...
HOW TO EXTRACT (or lookup) DATA FROM A PIVOT TABLE
replies , 11/8/2006, 4:42:48 PM
Hello! Sheet 1 contains the raw data. Sales and cost of sales for customers.=20 Sheet 2 contains the pivot table that summarizes the data in sheet 1.=20 In Sheet 3(a further summary of the Pivot...
replies , 1/25/2007, 6:14:11 AM
i have a date format like this - 13.02.2007(dd.mm.yyyy) i like to convert it to date so that i can sort it by date. i already used the format cells to change the category type to date but nothings...
counts of dates
replies , 2/1/2007, 12:53:19 AM
I have a list of dates from 1/1/2000 to 1/1/2007 and i want to get the sum of it monthly.i want to get the sum of 2/1/2006 to 2/28/2006. can you give me some tips? thanks!
opening excel file
replies , 3/12/2007, 6:45:19 AM
im using office 2000 sp3. when i try to open an excel file by double click the file or right click the file then Open suddenly the excel open but no workbook open.but when i open the file through...
INVENTORY CYCLE COUNT IN EXCEL
replies , 3/21/2007, 2:44:29 PM
Hello to all! I want to start an inventory cycle count program in my company. How can = Excel be used to do random selection? The only data I currently have is = a listing with the following...
Empty full sheet charts
replies , 5/8/2007, 11:43:17 PM
I've just upgraded from Office 2003 to Office 2007 on a Vista (32 bit) machine, however, I quickly discovered that in Excel when I use the "Move Chart" option to place a chart within a new sheet of...
replies , 10/4/2007, 10:39:10 AM
Hello All I am using excel 2000. I am creating a simple data-input sheet, where the user will be entering name, addresses, etc etc. - with each field in its own column. I would like a column for...
replies , 10/4/2007, 3:13:21 PM
Hello All This really follows on from my previous post. I have a worksheet that will be used for simple data entry of name, address, etc etc. - 1 column per field. One of the columns will be...
Excel 2003: Copy rows from one workbook into another without losing interleaved data
replies , 4/22/2008, 5:07:58 PM
Hi All, I have workbook#1 which contains rows of information which I need to copy into workbook#2. This is simple the 1st time but the data in workbook#1 does change and therefore periodically I...
2. Why this happening in Excel everytime?
replies , 7/4/2009, 2:25:22 PM
Hi friends, For the past few months, everyday I have to download 3-4 files from my banking site and I save those files in *.xls file format. But when I open any of these *.xls files, I get this...
searching for free data on internet
replies , 3/13/2012, 9:50:15 AM
good day everyone. please, how can i find free data on the internet to use for practice? xml, access, .xlsx etc. I know there are data sources out there one can use to practice for data analysis,...
stats analysis; website dedicated to
replies , 3/13/2012, 9:50:20 AM
i have googled to it and do not like the results i have. can anyone recommend a website dedicated to spreadsheet stats analysis, even if not specific to excel but provided excel can be ported to...
Re: Detecting and altering identical data in a column or row
Try Edit, Replace. Select the option "Match entire cell contains" so other YES's, etc., aren't replace. To limit to a range, select it first, else the entire sheet is searched. -- Jim Rech Excel...