# Tagged Questions

**0**

votes

**0**answers

13 views

### Changing the number in Excel each time I print (and for a range)

Basically I want to add an addittional input box for range printing.
Change the code from this thread:
Changing the number in Excel each time I print
to include another input box to determine the ...

**0**

votes

**0**answers

42 views

### Excel chart copying whole sheet into a new workbook - references to hidden rows are copied as absolute link

When in Excel 2013 I copy and rename whole sheet containing a chart into a new workbook, my references to series value ranges, axis labels etc., that have data in hidden rows, are not copied as ...

**0**

votes

**1**answer

46 views

### Excel: How can I copy cell contents from multiple sheets at once?

I would like to select cells in each sheet in my workbook and then copy them all at once, is that possible? Or even better, if I could mark those cells (group perhaps) so that I could get the SUM of ...

**0**

votes

**1**answer

322 views

### excel macro to look up data from a database and copy it to another excel file or sheet

I have an excel file which looks up and calculates data for a given date. It works as follows:
You enter the date in a specific cell (input) and in the same sheet the required data appears (20 cells). ...

**5**

votes

**4**answers

10k views

### How to insert empty rows in Excel 2013 when I have copied rows in my clipboard?

This seems like something which should be painfully simple to do but I can't figure it out. So with an empty clipboard I can right click on a row header and say insert row, no problem, it inserts a ...

**0**

votes

**1**answer

310 views

### Excel - how to copy all colums in a row based on a condition

I'm new to macros and hope somebody can help
Trying to make a report from a datasheet that meets some conditions.
I need to fetch all the data (cells) in a row e.g. that meet the condition <1 in ...

**4**

votes

**3**answers

4k views

### Copy/paste filtered column in Excel - error message

In short, I have filtered a worksheet by column A, and I want to copy/paste from column B to column C. Obviously I don't wish to copy/paste values from rows that were filtered-out here.
The above ...

**0**

votes

**1**answer

722 views

### How can I copy cells in Excel 2007 and paste with formatting

I am wanting to be able to copy cells in a worksheet and paste them elsewhere in the same worksheet while maintaining the original formatting. I also want to be able to paste into Word and Outlook ...

**6**

votes

**2**answers

2k views

### How to change the delimiter when you copy from Excel and paste to notepad

I would like to copy cells from Excel, and paste it to notepad with comma as delimiter, in stead of tab(which it is). Is there any way to do this without doing a replace in Notepad or saving the ...

**0**

votes

**4**answers

4k views

### Copying a hyperlink so that it works with a series

OK, this should be a no-brainer, but I cannot find anyone to help me with this:
Example
A5-K5 On worksheet 1 contains info relating to one specific item.
I want to have a hyperlink in L5 taking me to ...

**5**

votes

**2**answers

2k views

### How to paste table from MS Excel to Wolfram Mathematica?

When I am pasting a region from MS Excel, which contains multiple numbers, to Mathematica, I am getting just a long plain sequence of digits, i.e. one integer number in Mathematica.
How to have a ...

**0**

votes

**1**answer

532 views

### Excel 2003 “SHIFT+Copy” functionality - where is it in 2010?

i use the 2003 "SHIFT+Copy" function very frequently - eg every monthly. I have thus far been unable to find it anywhere in 2010 and have spent about 10 minutes searching MS on line.
Does anyone ...

**1**

vote

**1**answer

711 views

### Copy & paste a cell along with its name in Excel

Is there a way to copy a cell that also has a "name", and paste it somewhere else so that the new cell also has the same "name"?

**3**

votes

**5**answers

25k views

### Excel: copy cell formatting in equation

If I make an equation:
' on cell A2
=A1
Is there a way to make A2 have the exact same formatting as A1 and not just the value?
EDIT:
i.e. I want a FORMULA that copies both the value and the ...