@Poremsky.com

Tips & Tricks for Windows, Office, and Whatever

  • Home
  • Windows
  • Office
  • Web Design
  • WordPress
  • Internet Explorer

How to fix records that are all in one column

Published on August 1, 2024 Last reviewed on August 1, 2024

Copy the sorted data to a new sheet then save

How to fix Kaspersky Password Export… or any data that is in a single column, not rows and columns. A client wanted to know if there was an easy way to fix the exported password records so he could import into another password app. While he could use Excel’s Transpose to fix it, that is […]

Use local templates with Office 2013

Published on August 15, 2012 Last reviewed on August 1, 2024Last reviewed on May 5, 2015

A new feature of the Office 2013 applications is online templates. The Start screen window comes up when you double click on Word, Excel, and the other Office applications that make heavy use of templates.

Can't Preview Word 2010 Docs in Windows 7

Published on September 7, 2011

When you try to preview Office documents in the File, Open dialog, an error is returned. The same document previews as expected in Windows Explorer or other Office applications. Steps to repro: Open Word Go to File, Open Select a folder where there is a Word document On right, "show the Preview pane" selected (highlighted […]

Putting directory.asp and batch commands together in Excel

Published on July 11, 2011 Last reviewed on August 1, 2024Last reviewed on May 5, 2015Last reviewed on May 17, 2014

These are the steps I used to get a usable URL and create the code I needed for the batch file, in only a few minutes - using Excel. Open directory.asp in a browser. View source. Copy the section with the URLs. Paste into Excel The code will look like this: <li><a href="/folder/page1.asp">Page Title</a></li> <li><a […]

Recent Posts

  • Use a JavaScript bookmarklet to open an archive for a webpage
  • How to fix records that are all in one column
  • Change Password or Pin Complexity after removing from Intune
  • Server drafts location is not valid error message
  • What is the Brown File Box Icon on Files in Windows 11?

Recent Comments

  • FUAD on Remove Office Licenses from Windows
  • Brian DuBridge on Add the Recent Items Folder to Windows 10 Quick Access
  • Renee Moodie on Remove Office Licenses from Windows
  • John P on Remove Office Licenses from Windows
  • Puja on Remove Office Licenses from Windows
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.

To find out more, including how to control cookies, see here: Cookie Policy

© 2026 · @Poremsky.com