Skip to content

On Sheets

  • Home
  • About
On Sheets
Home / James Corrigan

Author: James Corrigan

How to Remove Margins in Excel: 4 Methods
General

How to Remove Margins in Excel: 4 Methods

ByJames Corrigan 2024-02-072024-02-07

Margin settings in Excel can sometimes affect the layout and presentation of your worksheet. Excel provides…

Read More How to Remove Margins in Excel: 4 MethodsContinue

How to Justify Text inside a textbox in Excel [4 Methods]
General

How to Justify Text inside a textbox in Excel [4 Methods]

ByJames Corrigan 2023-12-282023-12-28

Text boxes serve as a valuable tool for presenting and organizing information in Excel. The need…

Read More How to Justify Text inside a textbox in Excel [4 Methods]Continue

How to Convert UTC time to EST in Excel: 6 Ways
General

How to Convert UTC time to EST in Excel: 6 Ways

ByJames Corrigan 2023-11-292023-11-29

Have you ever found you needed to convert time between different time zones in Excel? Whether…

Read More How to Convert UTC time to EST in Excel: 6 WaysContinue

How to find last row from bottom up in Excel [VBA & Office Scripts]
General

How to find last row from bottom up in Excel [VBA & Office Scripts]

ByJames Corrigan 2023-11-292023-11-29

This article guides you on how to find the last row in your Excel spreadsheet. Manipulating…

Read More How to find last row from bottom up in Excel [VBA & Office Scripts]Continue

How to Remove First Character in Excel: 6 Top Ways
General

How to Remove First Character in Excel: 6 Top Ways

ByJames Corrigan 2023-10-032023-10-15

You may need to remove the first character, last character, or specific character in a string,…

Read More How to Remove First Character in Excel: 6 Top WaysContinue

How To Add Trailing Zeros in Excel [11 Methods]
General

How To Add Trailing Zeros in Excel [11 Methods]

ByJames Corrigan 2023-05-042023-05-04

Do you need to add leading zeros in Excel like 000203?  Default Excel will not allow you…

Read More How To Add Trailing Zeros in Excel [11 Methods]Continue

How to Round To the Nearest Dollar in Excel [9 Ways]
General

How to Round To the Nearest Dollar in Excel [9 Ways]

ByJames Corrigan 2023-05-032023-05-03

If you have received the data with decimals and round to the nearest numbers in Excel…

Read More How to Round To the Nearest Dollar in Excel [9 Ways]Continue

How to Convert 8 Digit Number to a Date in Excel [6 Ways]
General

How to Convert 8 Digit Number to a Date in Excel [6 Ways]

ByJames Corrigan 2023-05-022023-05-02

You want to convert 8 digits text representing date to Date in Excel for your project….

Read More How to Convert 8 Digit Number to a Date in Excel [6 Ways]Continue

How to Lock Pictures in Excel Cell
General

How to Lock Pictures in Excel Cell

ByJames Corrigan 2023-04-29

Do you need to insert an image, picture, object or shape in your report or dashboard?…

Read More How to Lock Pictures in Excel CellContinue

How to Sum Every Nth Cell in Excel
General

How to Sum Every Nth Cell in Excel

ByJames Corrigan 2023-04-29

Do you need to learn how to sum every nth cell in Excel? In this post,…

Read More How to Sum Every Nth Cell in ExcelContinue

Page navigation

1 2 Next PageNext

James Corrigan

Hello and welcome to my blog about Microsoft Excel.

More About Us
  • Privacy Policy

© 2025 On Sheets

Facebook Twitter Instagram
  • Home
  • About
Search