Convert column headings into rows

Trying to convert A1 - M1 into A1 - A12 without having to cut and paste each column heading into its own row.

Solutions to the Problem Convert column headings into rows

Download Error Fixer for Free Now

Try this...

• Select B1:M1
• Home.Copy.....(or the keyboard shortcut: CTRL+C)
• Select A2
• Home.Paste.Transpose

(Transpose won't let you paste over the source)

• Then clear cells B1:M1

Does that help?

Ron Coderre
Microsoft MVP (2006 - 2010) - Excel

If any post answers your question, please mark it as the Answer (so it won't keep showing as an open item.)

Because of this Convert column headings into rows error, Windows can fail in starting some processes and the system's performance can significantly slow down. In some cases, Windows has problems starting up and the system can freeze.

Lastly, this error Convert column headings into rows can even result in the Blue screen of death error message, just like other critical Windows errors. If any of the above problems and symptoms occur in your PC, then you should immediately seek to resolve this problem.

In order to resolve Convert column headings into rows error or repair the corrupted and damaged Windows files, you will need a Convert column headings into rows error repair tool. There is more than one method of treating this kind of error code, and here is how you can manually do it:

  1. Start the computer and log in as administrator
  2. Go to the start button and select All Programs. Go to Accessories, System Tools, and then System Restore
  3. Click on System Restore and in a new window, select the 'Restore my computer to an earlier time's option and click Next
  4. On the new confirmation window that appears, click Next
  5. Restart your computer after the restoration has been completed

Recommended Method to Fix the Problem: Convert column headings into rows:

How to Fix Convert column headings into rows with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Run it, and it will scan your computer. The junk files will be shown in the list.

2. After the scan is finished, you can see the errors and problems which need to be fixed.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.

Related: Can't Get Admin. Tools To Work In Windows 7, Except Config.sys,Can't Delete Messages In My Deleted Items Folder,Can You Print From Web Browser In Home Netwrek With Windows 8 Or 7 Whitout Having A Server Installed?,Can You Create A Form From A Report? Arghh I Hope So!,Can't Delete A Link In Favorites (Vista IE9),Changing FONT Size On Labels (Office Starter 2010 / Windows 7 ),Chrome Browsers Windows Incorrectly Reported To Be Open,Certificate Error - Cannot Open Adobe Files To Read Unless I Purchase Adobe Professional,Cgi Extensions,Cant See Small Windows Above My Task Bar When I Move The Mouse Over The Explorer Icon In The Task Bar Anymore,Computer Sleeps Immediately Upon Wakeup From Hibernation,Computer Locks On Me And Only Ctrl + Alt + Delete Restores It After Lock Up,Computer Restarts When I Put My Admin Password,Conditional Formatting Highlight Cells If A Date Falls Within A Given Week,Computer Does Not Shut Down When Turning It Off.
Read More: Fast Solution to Error: Connection to Internet Explorer,[Solved] Control panel not responsive,Troubleshoot:Control Panel\\All Control Panel Items\\Notification Area Icons blank Error,Troubleshooter of Error: CONVERT classified pdf to word doc,Troubleshoot:converting all earlier works files to ms office 2003 files,chkdsk cannot continue in read-only mode.,Citrix Go To Meeting Downloader,Changing the range of a named range,Conditional Format Problem...,Connect to my network but no access to internet
by FileRundll32Exe33 | 2016-09-23 17:29

compaq 8510p "no battery detected"

how can i force the computer to recognize and charge the battery?

Keys to the Problem compaq 8510p "no battery detected"

Download SmartPCFixer for Free Now

Hi Tony-holt,
The situation that you are describing can usually be fixed by performing a
Power Cycle on the laptop.
Perform the following.
a.       Shut down the computer.
b.      Unplug everything from the computer.
This includes the AC Adapter, Modems and Routers, and external devices, such as printers, drives, USB devices, etc.
Nothing should be left plugged into the computer.
c.       Remove the battery.
d.      Wait 30 Seconds.
Press and hold the Power Button on the laptop for
15 seconds.
This will drain all of the excess electrical energy out of the laptop.
e.      Plug everything back into the computer, including the AC Adapter and battery.
 Start the computer and check the results to see if the problem is resolved.
Let us know the results.

Using Windows troubleshooter:

  • Click on Search on Charm bar and type Troubleshooting. Click on the very first option.
  • A new window will open. Click View all from the left pane.
  • Scroll down to the bottom and click on Windows update.
  • Troubleshooter window for Windows update will pop up. Click on NEXT. It may ask you for administrative permission.
  • The troubleshooter will automatically detect problems and fix it.
  • Now, close this window and try download/install the app which was previously showing error.

Recommended Method to Fix the Problem: compaq 8510p "no battery detected":

How to Fix compaq 8510p "no battery detected" with SmartPCFixer?

1. Download SmartPCFixer. Install it on your computer.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.

Related: Can't Upload Photos Or Documents Using Window 7,Cannot Get Into My Hotmail Email On My Home PC But Can On Other PCs, Laptops And On The Phone,Can't View Desktop In Safe Mode Or Normal Mode After Java Virus Infection,Cannot Adjust Brightness Of The Screen Since Installing Windows 8.1,Cannot Open Internet Explorer, Receive Message: Application Not Found,Cannot Uninstall Programs And Getting An Error That I Need Rtl120.bpl File,Cannot Open Windows Live Mail, Error Message 0x80004002,Cannot Open Links In Mail "application Not Found",Cannot Run Videos That Use Active X After Installing IE8; I Think The Error Msg Below Which Mentions Add-ons May Be The Problem. Has Anyone Figured Out How To Fix This?,Cannot Open XLSX Spreadsheet,Certificate Error With Windows 7 & IE8 - Message: The Security Certificate Presented By This Website Was Issued For A Different Website's Address,Cant Get The Slide Title From An Excel Sheet Using VBA?,Changing The Home Page Back To The Original Setting-- How Do I Do This?,Classpnp.sys Issue - Need Recovery/reinstallation Disk,Changing The Color Palette In Excel 2007
Read More: Solution to Error: cant load juno email folder?__,How to Resolve - Checked in message on the CompanyWeb calendar page?,Troubleshoot:Changed computer - wrecked every single excel graph (if in separate tab) Error,Chart work, add source data to existing chart [Anwsered],How to Fix Error - Click on a game link in favorites error internet explorer can not display web page?,Can we use Wifi direct to share data from Phone to Pc like bluetooth,Can't change default window size of word documents,Can you automatically update a data validation drop-down list?,Cannot install security update KB 2653956,Charts and a line NOT displaying unless ...
by FileRundll32Exe33 | 2016-09-19 17:26

Cannot print pdf in reader

I have a specific document that will not print in reader.  My printer shows as an active device and I checked the properties of the pdf file and there is nothing unusual.  When I click print absolutely nothing happens, the file doesn't even show up in the
print queue.  Everything else prints correctly, that is after I go through the circus required to print from Microsoft reader.

Keys to the Problem Cannot print pdf in reader

Download SmartPCFixer for Free Now

How to Avoid Downloading Malware

Where are you getting the download?

There are malicious people who download valid copies of a popular download, modify the file with malicious software, and then upload the file with the same name. Make sure you are downloading from the developer's web page or a reputable company.

Don't install download manager

Many sites suggest or require you to install an installer or a download manager before allowing you to download a program you may be interested in downloading. These tools almost always cause your computer more problems and may even have malware or other spyware. Avoid any site claiming anything must be installed first before you can continue with your download.

Avoid advertisements on download pages

To help make money and pay for the bandwidth costs of supplying free the software, the final download page may have ads. Watch out for anything that looks like advertisements on the download page. Many advertisers try to trick viewers into clicking an ad with phrases like "Download Now", "Start Download", or "Continue" and that ad may open a separate download.

Cancel or deny any automatic download

Some sites may automatically try start a download or give the appearance that something needs to be installed or updated before the site or video can be seen. Never accept or install anything from any site unless you know what is downloading.

Recommended Method to Repair the Problem: Cannot print pdf in reader:

How to Fix Cannot print pdf in reader with SmartPCFixer?

1. You can Download SmartPCFixer here. Install it on your system. When you open it, it will perform a scan.

2. After the scan is finished, you can see the errors and problems which need to be fixed.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.

Related: Basing One Combo Box On Another,Batch File Execution Time Calculation,BitLocker: The System Could Not Find The File Specified,Best Way To Create Letterhead Electronically From Mailmerge,Battery Plugged In But Not Charging,Break Spreadsheet Into Weeks And Months,C:\Program Files X86 Browser Updater\TBUdater.dll.,Built New Computer With Windows 7 - Experiencing Same Data Transfer Issues,BSOD After Hibernation.,Built New Computer In Dec 2012 And Did Windows 8 Update, Restarted And Result Was Corrupted OS 'insert Proper Boot Device'?? Twice! Which Update Is Corrupting My Computer???,Can I Use The Same Recovery Discs To Restore Windows On Multiple Same Model Laptops?,Can You Use Spell Check On A Protected Sheet Using All Capitals?,Can Someone Download Apps Without A Microsoft Account?,Can Not Load Excel File By Clicking Workbook Icon,Can't Access Control Panel,Can't Save Hyperlinked Files, It's Forcing A Save As Instead,Can't Save Files On Desktop/,Can't Select Multiple Text Boxes,Can't See Other Computers On Network,Can't Open Certain E-mails Error Message C00d1199
Read More: Cannot Start up Win 7 Disk Error [Solved],How to Fix - Cannot upgrade Adobe reader 9?,Cannot open or save email attachments Windows Mail Anwsered,Solved Cannot upgrade iTunes or Windows Messenger error reads Could not access network location APPDATA,Fast Solution to Problem Cannot start Secure socket protocol Service error 1079,can't get an hp color laserjet cp1515 to print on windows 8,Can I reset my laptop to factory setting if I have had my hard disc drive replaced?,Cannot backup Windows 7 64bit - error code 0x80070020,Can't uninstall IE8,Cannot access Vista Print website - Error message "Website could not be found"
by FileRundll32Exe33 | 2016-09-14 11:43