Portfolio-Programming work-Utilities-

Partitioning Columns and Rows in Excel

Products in section
Utilities
News
Memory Game
Try the news on this portfolio
really non-standard
MEMORY GAME
Animals
Animated Films
World Cinematography The Walking Dead Avatar
EU
... and many other ...
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 shortcut key 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
Planned improvements to the next version
  • split multiple columns (rows) at the same time
  • consideration of anchoring walls
Download
Product detail
Published

January 13, 2015

Version

1.1

Price

free

Product type

excel utility

Compatibility

MS Office 2007 and above

OS

Win 11 / 10 / 8 / 7 / Vista / XP

Language

English
Slovak

Technology

Visual Basic for Applications (VBA)

Content

XLSM file

Keywords

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

Rating

Overall rating: 97.6 %
Your rating: