Portfolio-Programming work-Utilities-

Partitioning Columns and Rows in Excel

Products in section
Utilities
Partitioning Columns and Rows in Excel
Description

Simple Excel utility for splitting columns and rows without changes in edited sheet.

Another unique utility allows "seamless" cutting sections. Something that Excel not offer.

This utility can save a lot of time and energy, because it allows to insert additional rows and columns to data in Excel workbooks without any unwanted changes.
Properties

Often becomes, that is necessary in already edited sheet insert into column (row) one or more new columns (rows). This utility is trying to convert the above functionality without noticeable changes in the modified worksheet.

  • insertion different number of column (rows)
  • create a copy of the active (modified) sheet
Installation

- without installation

Procedure

Run file Partitioning_columns_rows.xlsm and excel file, in which is necessary to split (insert) singel columns (rows).

In specific (active) sheet is necessary to define column (row), which will be split by marking the column (row) and pressing Ctrl+D.

After entering number of parts (the number of splits) and press Start button is a created copy of the sheet formed on the active sheet to the defined column (row) inserts the specified number of splits.

Views
Application without specifying column (row) in a specific (active) sheet Opening an Excel workbook with specific (active) sheet A column label in a specific (active) sheet (e.g. column F) Column of a specific (active) sheet is required to enter the keyboard shortcut CTRL+D The specified number 5 splits concrete column Initial column F is splited into 5 approximately equal parts An advance copy of a specific (active) sheet Seamless splitting concrete column
Improvements
  • split multiple columns (rows) at the same time
  • consideration of anchoring walls
Notes
Download
Product detail
Published

January 13, 2015

Version

1.1

Price

free

Product type

excel utility

Compatibility

MS Office 2007 and above

OS

Win XP / Vista / 7 / 8 / 10

Language

english
slovak

Technology

Visual Basic for Applications (VBA)

Content

XLSM file

Key words

excel utility, splitting rows and columns, inserting rows and columns

Rating

Overall rating: 97.6 %
Your rating: