Adding page number to Word document is easy. However, if not done correctly while adding page number contents of header or footer gets deleted. This blog show the trick to insert page number without deleting header or footer in Ms Word. Correct way to insert page number Go to header (or footer) by double clicking the respective area. You can also do it by navigating Insert tab > Header (or… Read More »Insert page number in Word without deleting header/footer
Distinct in SQL removes all duplicate rows and maintains only one row for a group of duplicate rows. While working with huge data there may be a situation when you have multiple duplicate records in a table. While fetching such records, you want to fetch only unique/distinct records instead of fetching duplicate records. For such type of cases, DISTINCT is an keyword in SQL/PostgreSQL. It allows to show unique and distinct values.… Read More »Distinct Keyword in SQL/PostgreSQL
Spelling check feature helps Ms Word users to quickly locate and correct spelling & grammar errors. This feature is available for tons of different languages. You can also set language preference for selected text too. Following are the procedure to change spelling check language in Ms Word for Windows and Mac OS. Change spelling check language Select the text you want to mark as different language and do the following… Read More »How to change spelling check language in Word (Windows & Mac)
When you type, sometime Ms Word Capitalize first letter of sentences Capitalize first letter of table cells Capitalize names of day Although this is a useful feature of Word, sometime you may want to disable some of them. Steps to turn off auto capitalization in Word Open Autocorrect Options Windows Navigate Files → Options to open Word Options Navigate to Proofing and click AutoCorrect Options Navigate to Math Autocorrect tab Mac Navigate to Word → Preferences and… Read More »How to turn off auto capitalization in Word
While selecting text using mouse, Ms Word sometimes selects more than you need. This is one of the annoying feature of Ms Word and is one of the most searched in superuser. Steps to stop word from selecting more Navigate Files > Options to open Ms Word options window Click Advance Uncheck the box against “When selecting, automatically select entire word” in “Editing options” group Result After the above setting,… Read More »How to stop Ms Word from selecting more than you need
Ever wondered how to align text left and right on same line in Ms Word. The trick is to use tab spacing and is explained in following steps. Setting up tab space to align text left and right align on same line in Word 1: Make sure the “Ruler” is visible. Navigate to View Tab and check the box against “Ruler” to display ruler. 2: Change “Left Tab” to “Right… Read More »How to align text left and right on same line in Ms Word
The programming logic for finding the smallest number is easy. However, what if you want to find the second smallest number? This blog covers two different ways to find the second smallest number in the list by using Python. Method 1 (simple but inefficient): By sorting array The first program is the standalone program, where the user is asked to populated the list during run time. Then sort the list… Read More »Finding the Second Smallest Number in Array Using Python
Pi (π or Π) is one of the most commonly types Greek alphabets in Ms Word. Of the four different ways to type Pi symbol in Word, Math Autocorrect is my favourite. Apart from being the fastest of all, it has the easy to remember keyboard shortcut. Ms Word Pi shortcut Type \pi and hit spacebar to get lower case of Greek letter pi (π). Similarly, to get upper case… Read More »Ms Word shortcut for Pi (π or Π) symbol
Table of contents, page number, list of figures/tables/equations, figure/table/equation number and cross reference are some common example of fields. Sometimes you need to update all fields in Ms Word rather than updating each one by one. There are a couple of ways to do it. However, each method has its limitations and doesn’t update each type of field. This blog describes the correct procedure that ensure every field are updated… Read More »How to update all fields in Ms Word for Windows & MacOS
There are three different ways to type degree symbol in Mac. Place the cursor at the location where you need degree symbol and use any of the following methods. Three ways to type degree symbol in Mac Method 1: Emoji and Symbols (commonly used method) Navigate Edit > Emoji & Symbols to open symbol and emoji search window. Alternatively, you can also use “Control + Command + Space” keyboard shortcut.… Read More »How to Type Degree Symbol in Mac