How to Use Ctrl D in Excel, Word, Ppt, and Google Sheet

Control D shortcut

The shortcut command called Ctrl D, or Control D is used in a variety of applications on Windows and Mac computers. They are mostly used in Excel, Google Spreadsheet, Word, PowerPoint, and other applications. These are discussed in detail below. Ctrl D in Excel, and Google Sheets: Pressing ctrl d in Excel fills or overwrites … Read more

What is a Full-Screen Shortcut for all Windows and Mac Apps?

Full-Screen Shortcut for Windows and Mac Operating Systems of all applications

The full-screen shortcut is useful for showing the entire screen of the current document, spreadsheet, or anything of an application. Unlike maximizing a window, in the whole screen window, all tabs will be hidden. This window is especially useful when the current screen is not sufficient to view or do something. Full-screen keyboard shortcuts for … Read more

How to Add Breadcrumbs to any WordPress Website- 2022

General Settings of Rank Math

There are many ways to display breadcrumbs on WP Websites. To add these to any WordPress website you need to make sure your theme has the default support option, use the plugin, have this option in the SEO plugin, or you can add coding. Benefits of Using Breadcrumbs in WordPress: Enabling it on your WordPress … Read more

Advanced Undo and Redo in Word 2019 (Office 360)

Undo and Redo in MS Word

What most people don’t know is that undo and redo are usually more advanced and faster than Keyboard shortcuts and general commands. Let’s learn how to use it. What is Undo in Word? It means going back one by one to work that has been done previously in the document. What is Redo in Word? … Read more

¶ Show or Hide Paragraph Marks in Word – 2022

Paragraph Marks in Word

Paragraph marks are non-printable marks. This is useful for showing invisible characters related to the paragraph. For example, Word-to-word space, paragraph breaks, page breaks, tab spaces, and line breaks. Turn on or off paragraph marks in Word: On the Home tab, in the Paragraph group, click the paragraph mark icon to turn on it. To turn off … Read more

Shortcut key to creating a new folder in Windows and Mac

Shortcut Keys to Create a New Folder

A Folder is also called a directory or a catalogue and is used to organize files into it such as documents, videos, audio, photos, etc. To create a new folder on Windows and Mac using the shortcut keys/hotkeys, follow the steps underneath the screenshot. Shortcut Keys to Create a New Folder: Shortcut key for Windows: Press Ctrl+Shift+N to create it on a desktop … Read more

2 Ways to Set and Use Tab Stops in MS Word – 2023

Tab Stop Positions on Ruler

A tab stop is a term used to describe the location of a computer and a typewriter. When it comes to the typewriter it is used to stop the carriage movement through the adjustable end stop. Similarly, when it comes to computers it is used to set the insertion point in the document. You can … Read more

The Best Classic Editors – WordPress Plugins – 2022

Classic Editors -WordPress Plugins

Classic Editor is one of the best WordPress team-maintained official plugins that restores the old (“classic”) WordPress editor and the “Edit Post” window. It enables the usage of plugins that enlarge that screen, add old-style meta boxes, or rely on the old editor. According to the WordPress team, this plugin is the official WordPress plugin … Read more

The Best WordPress Image Optimization Plugins (Free Pro)

Resmush.it WordPress Image Optimization Plugin

WordPress Image Optimization plugins can greatly increase the speed of your web page. There are many plugins and tools to optimize, only a few of which will give us the expected results. However, in this article, you will learn optimization guides of the best free paid tools and plugins for WebP image converters. Free – … Read more

How to Insert a Caption in Word – 2022’s New

Insert a Caption in MS Word

A caption in Word means a short description of the table, equation, photograph, or other illustrations. It is used to describe something that can be published in a few words. What is a Caption? The caption means a short description of a Photograph or other illustrations. It is a photograph, also known as Cutline. How … Read more

The Top WordPress Gutenberg Block Editor Plugins – 2022

WordPress Gutenberg Block Editor Plugin

EditorsKit is one of the best Gutenberg block editor plugins. This lightweight WP plugin adds many special rich text formatting features. It saves a tonne of your valuable time if you use keyboard shortcuts. So what are you waiting for, install it now. Rich Text Formatting and Other Features By using the EditorsKit you can add … Read more

How to Remove AMP Pages Without Redirections in WordPress

Remove AMP Pages without Redirections in Wordpress

Most people don’t realize that removing AMP pages is very easy. But once you delete or disable any Google AMP Plugin it takes around 1 or 2 weeks for all amp URLs or pages to be completely removed from your website. Sometimes it can take more than that. However, amp pages can be deleted completely … Read more

Working with WordPress Bulk Edit Actions [Posts and Pages]

WordPress Posts and Pages

In WordPress, you can perform bulk edit actions for posts and pages quickly and easily. Instead of editing each post or page, you can select all posts or pages related to the same categories and edit them all at once. And let’s see how to do so WordPress Bulk Edit Actions After login into your … Read more

Nofollow, or Noindex Pages, Posts, or 404 in WordPress

Noindex SEO Pugin

A nofollow instructs search engines not to follow a specific link/link on your website. Noindex completely blocks unwanted web posts or pages on your WordPress website such as 404 error pages, and duplicate content pages from being followed by search engines. Doing so will not only improve the SEO of your website but also give the user … Read more

How to Change Cell Color Based on Value in Excel -2023

You can change cell colour in an Excel spreadsheet automatically by increasing or decreasing the number value in the cell. Through this process, one can easily find out the highest or lowest value. To do so, you can follow 2 methods explained in this article. Change Cell Color Based on Value in Excel Method 1: … Read more

How to Apply Accounting Number Format in Excel – 2022

Select the Range of cells with or without numbers

The accounting number format describes what a number refers to. For example, 100 dollars is represented by its currency symbol $100. Similarly, you can convert the numbers into the format of your choice. They are General, Number, Currency, Accounting, Short Date, Long Date, Time, Percentage, Fraction, Scientific, Text, Etc. Applying Accounting Number Format Select the … Read more

How to Use Total Formula in Excel – 2022

Sum or Total Formula in Excel

To use a total formula in excel, one must know the excel interface and basic knowledge of a cell, cell reference, row, column, range, mathematical operators, and the difference b/w formulas and functions. To return the total in excel, we have many formulas and functions. Total Formulas and Functions in Excel: To add numbers in … Read more

How to Create a Photo Album in PowerPoint – 2023

How to Create a Photo Album in PowerPoint

You can create a photo album in PowerPoint for your beautiful and favourite photo collections and present it to your loved ones. Not only that, but you can also present your photos related project meaningfully and beautifully to those who need it. To do so, follow the steps below. Steps to create a Photo Album: … Read more

How to Use Hyphenation in Microsoft Word – 2023

Hyphenation in Microsoft Word

Hyphenation in MS Word is used to break the last word of any line beyond the edge of the document and correct it by distributing equally to the current line and its bottom line. Doing so will give clear and uniform spacing for the text of the document beautifully. There is no need to justify … Read more

The Draw Tab in Word, Excel, and Ppt – 2023

Draw tab in Word, Excel, and Ppt

A Draw tab in Word is used to draw different coloured inks with Pen, Pencil, and Highlighter with different effects. Adding Draw Tab to the Ribbon If your ribbon doesn’t have a draw tab, then do the following to add it. To add the tab, click the “File” menu and select “Options” to launch a … Read more

How to use Freeze Panes in Excel Spreadsheet?

Freeze Panes (Freeze rows and columns)

Freezing the Upper, Left, or both parts (Row and/or Column Heading/s) to keep it visible while the rest of the worksheet scrolls up and down or left and right, called Freeze Panes. For example, If the data in the sheet is not fully visible or if you are working with the current data when you … Read more

How to Allow Edit Ranges in Microsoft Excel – 2023

Allow Edit Ranges Dialogue Box

Giving full, partial, or no permission to edit the content of a particular range in a worksheet and protecting the rest of the worksheet completely with a password is called Allow Edit Ranges. If you want to set a password for the entire worksheet and also give a password to a range of your choice … Read more

How to Split Text into Columns in MS Excel – 2022

Choose original data type

Columns are powerful features in Excel. With the right formatting, columns can be created to make your data readable to the readers in a way that looks great. Sometimes you may need to split a single column of text into multiple columns. For example, a single column may contain a table of contents or a … Read more

How to Apply Data Validation to a Range of Cells in Excel

Data Validation in Excel

Data validation is the application of ensuring that the data entered in an Excel spreadsheet matches the parameters set for it. It is used to compare or confirm the data entered with current data. If a user enters any restricted value into any cell of the pre-validated data, it will give a reminder-like message without … Read more

How to Transpose Data in Microsoft Excel -2022

Select and Copy Data

Transpose data means changing the row data to column data, or vice versa. This option is a part of the paste special in Excel. Steps to Transpose Data: For example, suppose you have the following data which is related to students’ details. SN First Name Last Name Roll Number Class Section 1 Vadithe Omkar 54 … Read more

Word Counter | Character Counter – All Tools- 2022

Online Word and Character Count Tool

A word count is the total number of words in a passage of the text in any document, application, online, etc. Word Count is required to determine some or an exact limit for professional work. If a word count does not have a specific standard, it wastes time, and money for a work-related career and … Read more

How to Fix or Replace Broken Images in WordPress

Fix or Replace broken Images in WordPress

If you’re using WordPress, there’s a good chance that it’s your CMS of choice. After all, with over 60 million users and counting, it’s the most popular content management system in use today. But what if something goes wrong after migrating your website? What if your site is hacked, and you lose all of your … Read more

Difference Between COUNT and COUNTA in Excel – 2022

Difference between count and counta in excel

There is a difference between count and counta in excel. A function called count counts all the numbers (only numeric data) in a range of the cells or in the selected cells, whereas a function called counta counts all the characters such as numbers, letters, and any other characters in a specified range of the … Read more