Hello, I have scoured the newsgroups and searched quite a few posts for what I would like to do. We will use cell R3 as an example. I have Office 2007 and I...

Hi there, I've got a list of products for my company but it is listed in product group, the products for that group coming underneath.. like...

Tenho uma tabela de valores acumulados como posso elaborar um grafico de pareto ou diagrama de pareto utilizando o excel 2007 home and student?

I am looking to set up up some sort of database that will alow me to enter data in Excel on one page and automatically enter this into a certificate which I...

Hello, I use a spreadsheet as a calendar with a separate sheet for each month. I have the days going across the top and a list of staff names down the side....

I have a cell with a full sentence in it. The cell is too small for that sentence so of course it carries over the cells to the right of it to display the...

Is there a way to allow rows to break across a page in Excel 2007?

I know how to arrange windows to look at multiple workbooks. But I want to have two worksheets displayed at the same time from the same workbook. Is there...

Hi, I want to be able to count between a date range and return the value yes. I will show you the formula I currently...

I am trying to create a column or line chart where a value for 9 variables are given for each month of the year. My problem is that the values are mostly...

Tried to find an answer but haven't found one yet. :( I have two sheets. On Sheet 1, I have a Demo Code (1, 2, 3, etc.) in A9:A17 and a total quantity column...

I have a column of numbers. Some are positive and others are negative. I would like to color "red" the cell with negative numbers and 'green' the positive...

I am trying to copy/paste the filtered (subtotals) on my worksheet of about 17,000 rows. I do this every week. Unfortunately, I am getting the following...

Does anyone have any suggestions on how to set the default format on excel 2003? such as font, size, center align, whenever I open, it is all set. Thanks in...

Does anyone have any suggestions on how to determine the value? For example, Under following columns: 1 174 198 222 7 180 204 228 9 182 206 230 A given...

Sent OP this Option Explicit Sub SAS_MakeTable() Dim lr As Long Dim c As Range Dim mm As Double Dim mr As Long Dim mc As Double

Guess I have a duel question. First, I have numerous columns of data, all numerical. New entries are entered at the end of the column. Is there a formula...

I have a spreadsheet with several hundred rows and many columns. The formula in column "C" sums values for all columns from "D" through the last column for...

I am doing a project for work and need to copy a interest formula to the next 214 months (Ipmt function). Ii am receiving an error when I try to fill the...

I imported a tab-delimited text file, with quotation marks as the text qualifiers. Excel removed the marks, and now I need to save the file back as text,...