Fill handle tool of Excel helps in applying a formula of current cell to other cells just by dragging. Some time because of some grinch this fill handle doesn’t show up. The following steps will help you bring back the fill handle in Excel. Steps to show/enable fill handle and cell drag-and-drop Steps for Excel 2010 and above Go to Files > Options In “Advance” Category, under “Editing Options”, check… Read More »How to enable fill handle/formula drag-and-drop handle in Ms Excel
Some time because of some glitch, numbers in heading gets blacked out in Ms Word. This annoying black box around heading can happen to any heading of Ms Word document, and bringing back the heading numbers can be a pain. This is also one of the most voted Ms Word questions in superuser with multiple answers. After trying different solution given in superuser and other sites (and videos), we found… Read More »How to get rid of annoying blacked out number in Heading of Ms Word document (PC and Mac)
How to get rid of annoying blacked out number in Heading of Ms Word document (PC and Mac)
Greek Alphabets are not readily available on our keyboards. If you want to write them on internet (basically HTML) or software’s like Ms Word, Notepad etc., you need to learn methods specific to them. One method that works everywhere including Ms Word is Alt Code method. To insert Greek symbol using this method, you simply type 3-digit numeric code for a Greek letter holding Alt key. Note that this method… Read More »Complete list of Alt code for Greek Alphabets
Complete list of Alt code for Greek Alphabets
Microsoft Excel provides a hand and powerful tool to sort data. The default Excel sorting options are setup to sort rows. Let’s say, you want to sort columns in Excel instead of rows i.e. you want to order columns based on data of particular row. This blogs exactly covers the process to sort columns along with Video demonstration. Sample data to sort Let’s say, I have a following data in… Read More »How to sort columns in Excel
How to sort columns in Excel
LaTeX provides lots of features for typing complex mathematical equations with ease compared to other softwares like Ms Word. Microsoft has recognized this and started supporting LaTeX in Office-365. However, if you have an older version of Ms Word you can still bring LaTeX equation into it. This blog covers 3 different ways to bring LaTeX equation in Ms Word. 1: Direct LaTeX support in Office 365 Office 365 version… Read More »LaTeX equation to Word (2007 to 365): 3 Methods [2022]
LaTeX equation to Word (2007 to 365): 3 Methods [2022]
Line is one of the most basic shape for drawing. Let’s say you want to draw a perfectly vertical or horizontal line in Ms Word or PowerPoint. Drawing it using precision using a mouse can be difficult and time-consuming. However, the following Ms Word and PowerPoint hack (along with video tutorial) ensures you get perfectly horizontal or vertical line every time. The same hack works in Ms Word and PowerPoint… Read More »Ms Word and PowerPoint hack to draw perfectly horizontal and vertical line
Ms Word and PowerPoint hack to draw perfectly horizontal and vertical line
Tables provides one of the best and compact way to organize and represent data as rows and columns. Sometimes we make a big table and then later on wonder that splitting table into smaller tables may better idea. If find yourself into a situation where you need to split table vertically then the following two methods (Split Table option or a faster keyboard shortcut) may help you do the task… Read More »How to split table in Ms Word + keyboard shortcut [2021]
How to split table in Ms Word + keyboard shortcut [2021]
The default page orientation in Ms Word document is Portrait. But some content (say graphic or table) may fit better on a Landscape page. It is this time when you need to change layout of one or few pages of the document to landscape. The step-by-step process to make selected text or one page landscape in Ms Word (without manually inserting multiple page breaks) is covered in here along with… Read More »1 click to make one page landscape in Ms Word [solved]
1 click to make one page landscape in Ms Word [solved]
![Right align page numbers in TOC [Ms Word]](https://www.pickupbrain.com/wp-content/uploads/2021/11/How-to-align-page-numbers-in-table-of-contents-in-Ms-Word.png)
Ms Word has a wonderful feature that enables you to create a table of contents (TOC) with page numbers in 1 click. In TOC It is desirable to left align contents and right align page numbers However, sometimes (especially while making custom TOC) page numbers of TOC sits next to the heading/contents and you need to right align page numbers as shown below. The following steps will help you achieve… Read More »How to right align page numbers in table of contents of Ms Word [2021]
How to right align page numbers in table of contents of Ms Word [2021]
Deleting page is simple, select the content of the page and delete it. Now imagine you want to delete a range of pages (say page 15 through 25 or more pages). Now selecting content of these pages to delete it can increasingly become a tedious task as the number of pages increases. You may wonder is there any simple way to delete range of pages in Ms Word. The following… Read More »Shortcut to delete multiple page (range of pages) in Ms Word