Free Microsoft Excel 2013 Quick Reference

Our company is altering the code of our item numbers. is there a way to

delete one letter from a line of symbols and add a prefix to the front at the

same time?

delete one letter from a line of symbols and add a prefix to the front at the

same time?

- How to get a long column of numbers to wrap and print on 1 page?
- Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet?
- How to add a new column with the previous column formula?
- Column of Numbers in xls to String of Numbers in txt
- VBA Code to create a chart for every row in excel
- How to add a drag-down list box in Excel
- How to find and replace with blanks or actually delete row
- How to get a user's user id in an Excel macro
- Creating a macro that is "editable" in an excel file.
- Can I insert a watermark in an Excel document?
- How to add a a word or number at the front and end of the column
- How to add a letter in front of each number in a cell
- How to add a letter in front of each number in a cell
- how to add a constant prefix to an existing list of populated cells
- How to add a fixed amount to all cells in a column
- How to get a column of numbers in ascending order?
- How to add every nth column in a table
- How to add a Comment for entire Column
- How to chart a large series of numbers
- How to add a certain amount of rows to row of formulas.
- How to find the largest change of values in a column
- How to populate a multi-column activeX listbox on a spreadsheet with an ADO recordset
- Adding more than 30 numbers in a column
- Round a whole column of numbers

be sorted in ascending order and then printed. I don't know of a way to sort

multiple columns together so that is why it is one long column. Is there a

way to get it to print as multiple columns across a page so as to not have

numerous pages with only 1 column on each?

Thanks.

spreadsheet that will automatically delete the spreadsheet at the date you

specified?

thanks,

Charlie

How can I write a macro to add a new column to the right of the last

column of my sheet , in a way that it also copy all the formulas from

the previous column?

regards,

Sean

multiple columns and export it to a comma deliniated string of text?

Thanks!

Jeff

I need to create a chart for each row in an excel document.

Ideally, each chart would go into a new sheet, there is about 300 rows and this is an example of the data:

Doctorate Msc/MA Postgraduate diploma Postgraduate Certificate Other diploma Other Certificate Other 4.01 0.2 0.2 0.5 0 0.2 0.2 0.2 4.02 0.57 0 0.14 0 0 0 0.43 4.03 0.25 0.5 0.25 0.25 0 0.25 0 4.04 0 0 0 0 0.5 0 0.5 4.05 0.14 0.43 0.29 0 0 0.14 0 4.06 0.18 0.09 0.64 0.09 0 0 0.23 4.07 0.67 0 0.17 0 0.17 0 0 4.08 0.14 0.29 0.86 0.04 0.04 0.04 0 4.09 0.17 0.67 0.83 0 0.17 0.17 0.33 4.1 0.57 0.29 0.14 0.14 0 0 0.14 4.11 0.33 0.21 0.67 0.08 0 0.08 0.13 4.12 0.22 0.17 0.94 0.06 0.06 0.06 0.06 4.13 0.17 0.33 0.33 0.17 0.33 0.67 0

I need the numbers on the left (e.g. 4.01 etc to be the title and doctorate etc to be the column headings. Can somebody help me with the VB code to do this?

I guess I need to create a chart and then loop through all the data but I have no idea how to do so.

Help is much appreciated,

Cheers!

list, it will give 1 to cell B1, If I choose b from my list, it will give 2

to the same cell B1, and so on. Thanks.

word filtered, and column b having garbage. I've tried a find and replace by

hitting space bar 8 times (filtered has 8 characters) and replace filtered

with a blank cell. Column B still has garbage. How can I delete any "row"

that says filtered and have the rows compress to get rid of the large void?

I'm talking about 33,000 rows being gone at one time instead of blocking and

deleting, blocking and deleting, etc.... Can anyone help with instructions

on how to delete the numerous rows of garbage in an Excel document with one

key stroke?

--

Patmarie985

trying to execute the macro? For example, If User_ID = SmithJo Then (where

User_ID is something that Excel would make available to me somehow). I know

Excel knows user ids that users use to log into their PCs and/or network

since it displays them when I click on Tools>Shared Workbook, for example.

Thanks!

I need some help from the expertise.

I want to create a macro that is editable in an excel file. What I mean is that the code is visual in the file and for example the file location of the files to be opened are visable as well.

If I could get some hints or links on how to do this I'd be very happy. I have created a simple excel file to try to visualize my idea what I would like the macro to do.

The thing is that I've seen this being done but I don't really know the best way of doing it.

Thanks

Niklas

Is it poss to have a printable watermark behind data in an Excel worksheet?

Using Excel 2002.

Using Excel 2002.

Does any one know how to add a word or number at the front and end of the column

example

BAM-022311 BAM-022411 BAM-050200P2 TO add WEBOE in the front

WEBOEBAM-022311 WEBOEBAM-022411 WEBOEBAM-050200P2 WEBOEBAM-051900P2

My next one I need help in is place a a number at the end but have it go up each row

example

WEB00000

WEB00000

WEB00000

TO

WEB000001

WEB000002

WEB000003

WEB000004

and so on.

front of each number in a cell without clicking in to each individual cell

and typing it in. (very time consuming and tedious) The problem is - it's not

all the cells but a majority, all of the numbers are in the same column. To

explain, these are documents in storage. Each item is assigned a number (not

in any particular numerical order but they have to stay in the order they are.

Example:

X39655

X39656

X39711

39662

39664

39665

The last three numbers need the X in front of them.

Any ideas? Thanks so much!!

I read this previous reply and I'm not getting it.......I'm Excel challenged

:-(

Use a help formula

=Sheet1!A1&"scc"

copy down/across, then copy and paste special as values in place ,

finally replace the old values with the new

Regards,

Peo Sjoblom

front of each number in a cell without clicking in to each individual cell

and typing it in. (very time consuming and tedious) The problem is - it's not

all the cells but a majority, all of the numbers are in the same column. To

explain, these are documents in storage. Each item is assigned a number (not

in any particular numerical order but they have to stay in the order they are.

Example:

X39655

X39656

X39711

39662

39664

39665

The last three numbers need the X in front of them.

Any ideas? Thanks so much!!

I read this previous reply and I'm not getting it.......I'm Excel challenged

:-(

Use a help formula

=Sheet1!A1&"scc"

copy down/across, then copy and paste special as values in place ,

finally replace the old values with the new

Regards,

Peo Sjoblom

I am trying to figure out how to add a fixed amount in percent (ie. 10%) to all cells in a column.

Here is an example:

Price:

1.00

2.00

2.50

3.00

3.00

5.00

I want to add 10% to everything in the above column to give:

Price:

1.10

2.20

2.75

3.30

3.30

5.50

The column has thousands of items so manual editing is not something I can complete this year ;-)

If this involves some kind of formula would this prevent me from exporting as a CSV file - or would the CSV simply contain the numbers rather than the underlying formula?

Apologies if this is a simple question but I am stumped :-?

Any help appreciated!

Thanks,

S

How can i get a column of numbers in ascending order? I have a column "Number", and i want the column to go from 1,2,3,4,....etc. Is there any way i can just write the first number and drag it down to get the rest?

Many thanks!

Thanks in advance. I am using Excel 2007.

I know it can be done as the person before me has done so, and I need to

create a new spreadsheet so that when someone scolls over a certain column it

pops up with instructions of what is needed to be in that column.

I hope someone can help me..............I know it is a simple process but I

am bogged down with alot of crap right now and can not rremember how.

Help PLEASE!

Thank you

Column C - Win/Loss Ratio W/L - (.05 - 5.0)

Row 3 - Batting Average BA - (1% - 100%)

_______1% 2% 3% 4%

___.05

___.10

___.15

Formula for 1st data point (Data represented - 1% BA; .05 W/L)

=((($C4)*(D$3*100))+(($C4-1)*(100-(D$3*100))))

This table results in a wide range of numbers with multiple price series.

Question:

What is the best graph type to use?

How can I clean it up to make it easily readable?

I have a row of data all linked to a column of data in another workbook, so essentially the formlas are transposed but not precisely as the row data is not picking up the column data in order, ie there are some gaps, the links are not consecutive etc.

I've manully created the first set of links, now i need to replicate the links but with each formula 5 rows down.

For example IF I've linked thes cells from another workbook

A25 A27 A28 A42

and now I want to link

A30 A32 A33 A48

i.e. the same increments but 5 rows down, is there any way to just add 5 rows to my original formula?

Cheers in advance

column of numbers, even if they are negative values.

EXAMPLE:

Column A1:A3 contains the following numbers

135.67

23.45

-256.77

I need to show the returned information in Cell B6.

Every function I use returns 135.67 as the largest but I need to return the

-256.77, (and show the negative sign). This is a very simple example but I

hope someone can help.

Does anyone know how to populate a multi-column activeX listbox on a spreadsheet with an ADO recordset

I am returning the field count and setting the number of columns needed in the list box, but I can't figure out how to load the list box with the data

Can I use "CopyFromRecordSet" some how? Must I convert the RecordSet into an array? What

Please supply example code. Thanks much in advance.

identifier in each row you wish to sum, like the word "total", etc), you

might look at the SUMIF function

Vaya con Dios,

Chuck, CABGx3

"Fredneck Angela" I am working on Excel 2003 and trying to add a long column of numbers.

Excel

> will not allow me to enter more than 30 cells to be added. They are not

> continuous (cells in a single column, but every other row).

>

> Can anyone help?

that to a whole column of numbers. Say the number is .4178, i want it to be

..42 and i want to do that to the whole column. Any help?