Help: My Microsoft Excel "Paste Special// skip blanks" feature isn't working!

Help: My Microsoft Excel "Paste Special// skip blanks" feature isn't working!
by

1 Answer

Answer :

this is probably stupid and fairly obvious, but did you try rebooting your Excel and/or your computer? And when you say the feature isn’t working, I assume you mean you check the box for it and yet it just ignores your command? Also, did you try using a brand new spreadsheet and see if the feature is working in that?
by

Related questions

In Microsoft Word - how do I paste Excel spreadsheets properly?

Description : In Microsoft Word - how do I paste Excel spreadsheets properly?

Last Answer : I usually open a text box in word, then highlight the cells in the spreadsheet that I want to paste into the text box, and paste the cells into the text box.

Is it illegal to copy and paste an invitation onto Microsoft Word if the invitation isn't meant to be free?

Description : Is it illegal to copy and paste an invitation onto Microsoft Word if the invitation isn't meant to be free?

Last Answer : Yeah, I think that’s called copyright infringement.

Help find/setup a keyboard shortcut to "Paste Special > Unformatted Text" in Microsoft Office?

Description : Help find/setup a keyboard shortcut to "Paste Special > Unformatted Text" in Microsoft Office?

Last Answer : answer:Found a third-party app that'll help: PureText. It's super simple when running, it puts a PT icon in your systray. And then, to Paste Special > Unformatted Text, you hit Windows- ... specific macro as it works across apps. Still, I'm open to any other suggestions the Collective might have.

How do you paste information from Numbers (like Excel) into Pages (like Word) WITHOUT the grid --- so that just the text shows up, separated by tabs)?

Description : How do you paste information from Numbers (like Excel) into Pages (like Word) WITHOUT the grid --- so that just the text shows up, separated by tabs)?

Last Answer : answer:This is a really clunky solution. In numbers select File -> Export -> Save as PDF. Then you can open that PDF and copy and paste into Pages and it will lose the formating. I wish I knew of a better way. I have been trying for about 20 minutes and that is the best I could come up with.

Is there a free feature for removing duplicate columns/rows in Microsoft Excel?

Description : Is there a free feature for removing duplicate columns/rows in Microsoft Excel?

Last Answer : answer:you can do this without adding software. http://support.microsoft.com/kb/262277 I think this should work with all versions of Excel. if you're using a mac, the menus might be a little different, but ... tricky if you need to get rid of duplicate data in a specific column, but it can be done.

Is there a way to turn letters upside-down or backwards in Microsoft Word? Or, some application that does this that I can use and then copy/paste the symbol into a Word document?

Description : Is there a way to turn letters upside-down or backwards in Microsoft Word? Or, some application that does this that I can use and then copy/paste the symbol into a Word document?

Last Answer : answer:I see the chars you wanted explained on Wikipedia. You can simply copy & paste from there. If you're looking for a more direct approach, try using the Cambria Math font it has ... > System Tools > Character Map for a comprehensive list. Word offers similar functionality at Insert > Symbol.

Can any of you tell me how to access the embedded games the good engineers at Microsoft insert into Excel?

Description : Can any of you tell me how to access the embedded games the good engineers at Microsoft insert into Excel?

Last Answer : From what I’ve gathered, Vista and 7 don’t have any.

How to export search results from Microsoft Excel?

Description : How to export search results from Microsoft Excel?

Last Answer : answer:If you highlight the labels at the top of each column, then click on the data tab, and the big filter button.. you'll be able to sort out which ones are from New Jersey. ( ... paste those into a new spreadsheet. Without actually seeing an example of your spreadsheet this is my best guess.

Why does Microsoft Excel do this with graphs and how can I fix it?

Description : Why does Microsoft Excel do this with graphs and how can I fix it?

Last Answer : Can you e-mail me the file? I will play with it. You should know my e-mail Inverted Treestump..

Microsoft Excel for Mac 2001?

Description : Microsoft Excel for Mac 2001?

Last Answer : You might try uninstalling the program, uninstalling Office and then reinstalling it.

Microsoft Excel Question?

Description : Microsoft Excel Question?

Last Answer : Not that I know of. However, what I would do instead is link to the folder, without the file name, since you are updating the folder contents. Then the link will always go to a view of what’s in the folder. (It is one more step for users when following the link, though.)

Is the feature that allows you to go exactly where you want to, (skip or go back) missing in some podcasts?

Description : Is the feature that allows you to go exactly where you want to, (skip or go back) missing in some podcasts?

Last Answer : Sounds like a glitch, maybe email them to ask?

In Microsoft Word shortcut for delete is _______: a) undo something b) paste something c) redo something d) end something e) None of The Above

Description : In Microsoft Word shortcut for delete is _______: a) undo something b) paste something c) redo something d) end something e) None of The Above

Last Answer : a) undo something

Did you know there is an E-sport competition for Microsoft Excel?

Description : Did you know there is an E-sport competition for Microsoft Excel?

Last Answer : I didn’t know. I might watch a bit of it.

Why does Microsoft Excel sometimes calculate things differently?

Description : Why does Microsoft Excel sometimes calculate things differently?

Last Answer : answer:I can't duplicate your problem. I added those nine numbers to excel, summed the column, and divided by 9. I get 5.233333 if I increase the decimal points, I keep getting more 3s. If I ... me. I also used Average() and got the same correct result. How are you calculating average in Excel?

How do i put a overline on top of a letter in microsoft excel?

Description : How do i put a overline on top of a letter in microsoft excel?

Last Answer : answer:Hi, and welcome to Fluther. It's not at all certain that you can do what you want to with most commercially available fonts, including all of the fonts that ship with Microsoft products in the ... internal font to enable us to write the company name in logo type whenever that is called for.

In Microsoft Excel, can you change the settings of the representative bars so they are not all the same colour?

Description : In Microsoft Excel, can you change the settings of the representative bars so they are not all the same colour?

Last Answer : If they are in the same data set, they will be the same color. If you plot more than one group of data, then the different sets will have different colors. Say I'm plotting fruit sales at ... there would be one bar of each for each month with a magnitude proportional to the number of fruit sold.

How do you use labels on a scatter map in Microsoft Excel?

Description : How do you use labels on a scatter map in Microsoft Excel?

Last Answer : No idea, but welcome to Fluther. =]

I want to learn Microsoft Excel in & out.Can you suggest me all online links to learn Microsoft excel 2003 or 2007?

Description : I want to learn Microsoft Excel in & out.Can you suggest me all online links to learn Microsoft excel 2003 or 2007?

Last Answer : I know someone who did this by going to help and using the Microsoft online tutorials. It’s a pretty amazing way to learn it. Otherwise, you’re only picking skill up on a need to know basis.

What is a good software package to make VERY quality charts and graphs to submit to academic journals (i.e., better than Microsoft Excel)

Description : What is a good software package to make VERY quality charts and graphs to submit to academic journals (i.e., better than Microsoft Excel)

Last Answer : If you’re on a mac, iWork ‘09 make some incredibly nice looking charts.

How do I get started on my Microsoft Excel for my own household use?

Description : How do I get started on my Microsoft Excel for my own household use?

Last Answer : First I'd like to keep track of my income my monthly income secondly I'd like to keep track of expenses via holding onto receipts and putting them in my spreadsheet so that I can follow my expenses versus my income and not go over

Can data from OpenOfficeCalc be transferred to Microsoft Excel ?

Description : Can data from OpenOfficeCalc be transferred to Microsoft Excel ?

Last Answer : Need Answer

How do you recover a corrupted file in Microsoft Excel?

Description : How do you recover a corrupted file in Microsoft Excel?

Last Answer : When Microsoft Excel detects a corrupted workbook upon opening,it automatically starts File Recovery mode and attempts to repairthe workbook. If File Recovery mode doesn't start, try using thismanual ... able to recover your data, pick ExtractData to extract values and formulas from the workbook.

What is the Definition of command group in Microsoft excel?

Description : What is the Definition of command group in Microsoft excel?

Last Answer : What is the answer ?

Where can I get free Microsoft Excel training?

Description : Where can I get free Microsoft Excel training?

Last Answer : Free training for Microsoft Excel can be found here: Microsoft Excel Training & Word 2007 Tutorial - Learn Free Office", the address is: www.free-training-tutorial.com.

Are there classes in Microsoft excel I can take?

Description : Are there classes in Microsoft excel I can take?

Last Answer : There are a number of classes you could take to learn to use Microsoft Excel. Microsoft itself offers online classes at http://www.microsoft.com/learning/en/us/ training/format-online.aspx. ... or community college would also be a good source of information about learning Excel in the classroom.

Does Microsoft offer Excel training online?

Description : Does Microsoft offer Excel training online?

Last Answer : Yes, you can take training online. This will give you a lot of information. Microsoft offers trainings quite often.

Which of the following is System Software? A. Microsoft Word B. Microsoft Excel C. Adobe Photoshop D. Windows 7

Description : Which of the following is System Software? A. Microsoft Word B. Microsoft Excel C. Adobe Photoshop D. Windows 7

Last Answer : D. Windows 7

Which of the following is/are example(s) of Spreadsheets? A. Microsoft Excel B. Lotus 1-2-3 C. Both (A) and (B) D. None of the above

Description : Which of the following is/are example(s) of Spreadsheets? A. Microsoft Excel B. Lotus 1-2-3 C. Both (A) and (B) D. None of the above

Last Answer : C. Both (A) and (B)

9 Melissa was a _____macro virus: a) Microsoft Word b) Microsoft Excel c) Internet d) Microsoft Power Point e) None of These

Description : 9 Melissa was a _____macro virus: a) Microsoft Word b) Microsoft Excel c) Internet d) Microsoft Power Point e) None of These

Last Answer : a) Microsoft Word

Microsoft Excel is a ________application: a) Talbex Sheet b) Page Sheet c) Spread Sheet d) None of These

Description : Microsoft Excel is a ________application: a) Talbex Sheet b) Page Sheet c) Spread Sheet d) None of These

Last Answer : c) Spread Sheet

9 Melissa was a _____macro virus: a) Microsoft Word b) Microsoft Excel c) Internet d) Microsoft Power Point e) None of These

Description : 9 Melissa was a _____macro virus: a) Microsoft Word b) Microsoft Excel c) Internet d) Microsoft Power Point e) None of These

Last Answer : a) Microsoft Word

When plotting the segment locations for each round a. the goal is to determine the ideal spot location for each segment during the 8 years. b. the goal is to determine which products are the highest in demand. c. you use price on one axis and performance on the other. d. you should use Microsoft Excel. e. all of the above.

Description : When plotting the segment locations for each round a. the goal is to determine the ideal spot location for each segment during the 8 years. b. the goal is to determine which products are the highest in ... and performance on the other. d. you should use Microsoft Excel. e. all of the above.

Last Answer : a. the goal is to determine the ideal spot location for each segment during the 8 years.

Which one of the following is an example of Operating System? (A) Microsoft Word (B) Microsoft Excel (C) Microsoft Access (D) Microsoft Windows

Description : Which one of the following is an example of Operating System? (A) Microsoft Word (B) Microsoft Excel (C) Microsoft Access (D) Microsoft Windows

Last Answer : (D) Microsoft Windows

Which application in Microsoft Office is feasible for preparing presentations ? (1) Microsoft Excel (2) Microsoft Word (3) Microsoft Power Point (4) Microsoft Publishers

Description : Which application in Microsoft Office is feasible for preparing presentations ? (1) Microsoft Excel (2) Microsoft Word (3) Microsoft Power Point (4) Microsoft Publishers

Last Answer : Microsoft Power Point

Is it better to skip college in favor of getting a job and working up?

Description : Is it better to skip college in favor of getting a job and working up?

Last Answer : People with degrees get paid more. They make significantly more than those without degrees. Each more advanced degree is worth even more in terms of annual salary. Over the course of a lifetime, a ... a person does well without a degree. But on average, people with degrees make significantly more.

What menu is selected to cut, copy, and paste? 1) File 3 2) Tools 3) Special 4) Edit 5) None

Description : What menu is selected to cut, copy, and paste? 1) File 3 2) Tools 3) Special 4) Edit 5) None

Last Answer : Answer :4

To find the Paste Special option, you use the clipboard group on the _______ tab of power point a) Design b) Slide show c) Page layout d) Home e) None of these

Description : To find the Paste Special option, you use the clipboard group on the _______ tab of power point a) Design b) Slide show c) Page layout d) Home e) None of these

Last Answer : d) Home

What is happening to image files I download? They show up as blanks. Any ideas?

Description : What is happening to image files I download? They show up as blanks. Any ideas?

Last Answer : Have you tried saving any of the images as JPEG? Do you have a link to the site?

Why isn't my SteelSeries Stratus XL controller working properly?

Description : Why isn't my SteelSeries Stratus XL controller working properly?

Last Answer : Some of those controllers when first setting them up have internal capacitors that need to be discharged. With it powered press all the buttons like 50 times repeatedly. If that does not fix it you could have driver/mapping issues or a faulty button on the controller itself.

Why isn't the sound on some videos working?

Description : Why isn't the sound on some videos working?

Last Answer : I can't say for sure, but I was having problems with no sound on Youtube videos 2 days ago, whereas my Netflix sound was just fine. I tried fiddling with the volume on my computer and that didn't fix the ... that is on my PC. If it's not that, then you may have to get an updated version of Flash.

Sound isn't working on my internet?

Description : Sound isn't working on my internet?

Last Answer : Have you tried closing the Firefox application and then re-running it (as opposed to closing the window and re-opening the window)?

Winzip 8.1 isn't working for me. Why not?

Description : Winzip 8.1 isn't working for me. Why not?

Last Answer : What was in the Zip ? If it is a Word document, you’ll need the Word application on your computer. Also if the Word document was saved with a recent version of Word, you may not be able to open it. There is a Word “reader” for XP, it can only read the document.

Why isn't Adobe Flash working properly on my computer?

Description : Why isn't Adobe Flash working properly on my computer?

Last Answer : answer:The only thing I can suggest is the following: 1- Totally delete all traces of flash from the computer. 2- Delete all traces of any of flash's friends, such as shockwave. 3- Restart the ... flash used to have problems with active x some times, not sure if that still happens. Probably not.

Why isn't my mom's new charger working?

Description : Why isn't my mom's new charger working?

Last Answer : I have problems with my Macbook charger as well. I have to wiggle it back and forth until the light comes on and then wait a second until it starts charging. After my first charger went out, I had to buy a whole new battery. Make sure it’s really the charger and not the battery.

Windows Live Messenger (or MSN) isn't working properly. How should I fix it?

Description : Windows Live Messenger (or MSN) isn't working properly. How should I fix it?

Last Answer : I would never use the traditional client. I've used pidgin for many years: http://www.pidgin.im/ and have recently switched to digsby: http://www.digsby.com/ Because it does everything in one, including ... Maybe we could get a fluther app for it too ;) Until you get a more relevant answer :)

Is it possible in C++ to declare a vector of characters as a private variable in a class header file? If so, why isn't it working for me?

Description : Is it possible in C++ to declare a vector of characters as a private variable in a class header file? If so, why isn't it working for me?

Last Answer : Just throwing this in. Have you cleaned, before you execute?

Why isn't my computer working?

Description : Why isn't my computer working?

Last Answer : answer:i have a feeling that you are computer maybe infected by spyware. The first thing you should do is switch to the firefox browser. Then get some freeware anti-spyware tools to run a scan like ... VIsta's :system restore tool and it should be able to restore vista to its last working setting.

If I just copy-paste my C:\ drive onto a new one, can I just then replace the old drive with the new?

Description : If I just copy-paste my C:\ drive onto a new one, can I just then replace the old drive with the new?

Last Answer : Better question: Could I setup RAID easily? I’m pretty sure my board supports it.

Is it possible to just copy and paste whatever is one side of the screen?

Description : Is it possible to just copy and paste whatever is one side of the screen?

Last Answer : What are you trying to copy from? Make sure you click just brely away from the text and it should work, or copy all of it and delete it when you paste it.