This tutorial demonstrates how to create a slider bar in Excel. Create a Scroll Bar The built-in scroll bar in Excel lets you scroll the whole worksheet, but you can also create your own scroll bar that only applies to a specific range of cells. This can be useful when you have large sets of… Continue Reading
This tutorial demonstrates how to hide vertical and/or horizontal scroll bars in Excel. Hide Horizontal Scroll Bar By default, horizontal and vertical scroll bars are displayed in Excel. But while working in Excel, you may need to disable a user from scrolling horizontally or vertically in a worksheet. To hide the… Continue Reading
This tutorial demonstrates how to make the top row stay visible in Excel and Google Sheets. Freeze Top Row In a large worksheet with headings, you might want to make sure that the top row repeats when scrolling, so you can always see it. In the Ribbon, select View > Freeze Panes. … Continue Reading
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic… Continue Reading
In this ArticleTurn On ScrollbarsTurn Off ScrollbarVBA Coding Made Easy You can toggle scrollbars On or Off using a macro: Turn On Scrollbars Sub TurnOnScroll() With ActiveWindow .DisplayHorizontalScrollBar = True .DisplayVerticalScrollBar = True End With End Sub Turn Off Scrollbar Sub TurnOffScroll() With ActiveWindow .DisplayHorizontalScrollBar = False .DisplayVerticalScrollBar = False End With End Sub VBA… Continue Reading
You may need a workbook to always open to a specific view or location on a sheet, or possibly just change the view from a macro. You can do this by using the ScrollRow and ScrollColumn. ScrollRow Used to programmatically scroll a spreadsheet vertically. This example will scroll a spreadsheet to row 5. ActiveWindow.ScrollRow =… Continue Reading
This article will demonstrate how to link an RSS feed to Excel To link an RSS Fed to Excel you have two options: Add an XML Map Link the feed to Excel. Add an XML Map To add an XML map to your Excel sheet, follow these steps: Have a workbook open where… Continue Reading
Shortcuts to Move Around a Worksheet Move One Cell When you press an arrow key, your pointer moves one cell in the direction of the arrow key that you pressed. PC Shortcut:↓ or ↑ or → or ← Mac Shortcut:Arrow Google Sheets uses the same shortcut. Enter Text and Move Down When you… Continue Reading
In this ArticleFile Locked for EditingWorkbook Locked for EditingSheet or Sheets Locked for EditingDelete Temporary Files This tutorial demonstrates how to unlock an Excel file that is locked for editing, when the name of the person locking the file is your own. File Locked for Editing Say you are Fred Smith and you get the… Continue Reading
This tutorial discusses some possible ways to fix the “waiting for OLE action” error in Excel. OLE stands for object linking and embedding. It was developed to allow Office applications to interact with other programs. Excel sends a command to another application like Word or PowerPoint for example, and then wait for that… Continue Reading