Question about Microsoft Excel for PC

1 Answer

Quote numbers Hello, I have a program that each time I open would like that it is given a sequential number. Can anyone help please. thanks in advance

Posted by on

  • 4 more comments 
  • don1167 Feb 21, 2008

    Thank you for responding to my request. This is actually a file that I created to quote jobs on for my customers. What I would like for the program to do is each time I open it that it gives that particular file a quote number and then I save as "file name". I'm using Excel 95 and operating on XP.



    I can send you a copy of the file so that you can actually see what I need.



    Please let me know.



    Regards,



    Donald

  • cedric12 Feb 22, 2008

    how do i get in

  • Maggie B May 11, 2010

    Don:
    Got a good one... I'm plugging it in to YOUR workbook that you sent me to make sure it's all good to go! Keep your fingers crossed and hang in there!

    Maggie

  • Maggie B May 11, 2010

    Just a quick update for you: I have the macro/vba that I thought you'd need to do this... I just need to make sure it works and will work in YOUR version of Excel....

    Your patience is appreciated!
    Maggie

  • Maggie B May 11, 2010

    You're welcome! Yeah, please go ahead and send me a copy of the file... my email address is maggieboby@comcast.net.

    I'll take a look and see what I can do for you.. I'm sure it's just a simple macro that we can pop in.

    Maggie

  • Maggie B May 11, 2010

    Is this a saved filed that you run in Excel? Or.. is it a 'program' in the sense that it something that someone created and in order to use it, it opens in Excel?

    Also, what version of Excel are you using, and what operating system (i.e. XP, Vista, etc.)

    Thanks!
    MaggieB

×

1 Answer

You're the best, I knew that you would come through for me. Whatever I can do for you, let me know. Thanks, Don

Posted on Feb 23, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that 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.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Cell freeze 3 rows together at a time.


Freeze a Row in Microsoft Excel
Microsoft Excel 2010 can freeze, or lock, a top row as you scroll down the worksheet.
For example, you may need to keep the top row of column titles visible at all times.
The "View" tab on the command ribbon contains the "Freeze Panes" button in the "Window" group.
A single row or a range of rows can lock through the "Freeze Top Row" or "Freeze Panes" options.

Open the Excel worksheet.
Click the top row heading.
The row heading displays a number just left of the first column of cells. The selected row appears shaded.


Click the "View" tab on the command ribbon.
Click the "Freeze Panes" button in the "Window" group.
A list of options appears.

Click the "Freeze Top Row" option.
A black horizontal line appears on the worksheet.
This line indicates the locked row that stays on the screen as you scroll down the worksheet.

http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP010342542.aspx?CTT=1
Freeze or lock rows and columns
also
Use Freeze Panes in Excel
Scrolling down to look at a number and then scrolling up to make sure the number you looked at is under the header you expected is not an efficient way to view a spreadsheet.
The Freeze Panes feature of Excel allows you to freeze the labels of your data in place while you review the data.
Follow the instructions in Section 1 to freeze the top row or the left column.
Freeze multiple rows, multiple columns, or rows and columns, by following the instructions in Section 2.Freeze the Top Row or Left Column
1
Open the Excel spreadsheet.
2
Navigate to the "View" tab on the top menu.


3 Click on "View," then click on "Freeze Panes." A drop-down menu opens.

4

Select the "Freeze Top Row" option to freeze the top row.

5

Select the "Freeze Left Column" or "Freeze First Column" option to freeze the left column.

6

Freeze the top row by using the keyboard and sequentially pressing the keys "ALT, W, F, R." Ignore Steps 3 through 7 if using this choice.

7

Freeze the left column using the keyboard by sequentially pressing the keys "ALT, W, F, C." Ignore Steps 3 through 7 if using this choice.

8

Unfreeze panes by repeating Steps 3 through 5 and selecting "Unfreeze Panes" or sequentially press the keys "ALT, W, F, F."

Freeze Rows and Columns, Multiple Rows, Multiple Columns, or Multiple Rows and Columns
9

Open the Excel spreadsheet.

10

Freeze column(s) and row(s) at the same time by selecting the cell to the right of and below the location you want to freeze.

11

Freeze multiple rows only by selecting the cell in the left (first) column below the rows you want to freeze.

12

Freeze multiple columns only by selecting the cell in the top row to the right of the columns you want to freeze.

13

Navigate to the "View" tab on the top menu.

14

Click on "View," then click on "Freeze Panes." A drop-down menu opens.

15

Select the "Freeze Panes" option. You have now frozen the columns or rows, or columns and rows you designated.

16

Freeze panes using the keyboard by sequentially pressing the keys, "ALT, W, F, F." Ignore Steps 5 through 8 if using this choice.

17

Unfreeze panes by repeating Steps 5 through 7 and selecting "Unfreeze Panes" or sequentially press the keys, "ALT, W, F, F."



http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP001217048.aspx
Freeze or lock rows and columns
http://office.microsoft.com/en-us/excel-help/demo-hide-or-unhide-rows-and-columns-HA010241040.aspx
Hide or show rows and columns

Aug 14, 2013 | Microsoft Office Computers & Internet

1 Answer

Activation code for Corel draw x6


Need your help... I need activation code for Corel Draw X6, serial number: DR16R22-K4MG9LH-3V6RE29-VB76G6J Thanks in advance. if something else is need it please let me know it.Thanks in advance

May 28, 2013 | CorelDRAW Graphics Suite X4 for PC...

1 Answer

I am also searching for the office standard 2007 produck key!! iF anyone have please send me I am waiting and searching for more than two days so kindly help me!! my email is given below sweeti...


Hi, Why don't you try follow these steps: - Go to this link http://keygenguru.com/search/?search=microsoft+office+2007&key=Search - Go to the keygen of the version of office 2007 you possess. - Click on show serial number then use that serial number
I Hope this helps

Nov 20, 2010 | Microsoft Office Standard 2007: Windows

3 Answers

How to round the fig. in Excel 2007 E.g. 12350*32.75% = 4044.625 I want it to be rounded to nearer rupee. If the decimal is lesser than 50, rounded fig. should be lower Rupee if the decimal is more than 50...


The function is called ROUND. It has 2 arguments, (1) the original number and (2) the number of decimal digits. Here is the Excel's help: ROUND(number,num_digits) The number you want to round. None. num_digits The number of digits to which you want to round number. If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places. If num_digits is 0, then number is rounded to the nearest integer. If num_digits is less than 0, then number is rounded to the left of the decimal point.
So for your case use this in a cell "=ROUND(12350*32.75%, 0)" without quotes, where I assume one or both numbers will come from other cells. -Ken

Aug 29, 2009 | Microsoft Office Excel 2007

1 Answer

Help me with the photoshop CS3 authorization code


Yes. If you actually purchase the program, you will get a working, valid serial number and activation number. To do it any other way is called STEALING and we can't help you be a THIEF.

May 08, 2009 | Adobe Photoshop® CS3 Extended Full Version...

1 Answer

Online activation


what msoffice version are you using? if you are using the msoffice 2007, launch a program then click the office icon and go to option and you should get to read activation. from there you will be given two options how you would like to activate your program either by phone or online. if online fails it will give you the phone support number you need to call to have your software activated

May 19, 2008 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

28 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18331 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...