Skip to content
Code for Devs
  • Home
  • JavaScript
  • WordPress
  • Excel
  • VBA
  • C#
  • Miscellaneous
  • Contact Us
  • Home
  • Excel

Category: Excel

Group Concat in Excel-Concatenating Cell Values based on Grouping Rows

May 24, 2025May 24, 2025 codef4devs

In this article we would learn how to combine data from multiple rows into one single string in Excel There is no specific function in Excel to concatenate data from multiple rows into one field. […]

Leave a commentExcelExcel

Calculated Fields – Excel Pivot Table Advanced Feature

July 23, 2023July 23, 2023 codef4devs

Insert Calculated Fields feature of Pivot table enable you to add a virtual column, based on some calculation over existing columns, which is physically not present in dataset but gets available in Pivot Table fields. […]

Leave a commentExcel

How to Protect an Excel File with Password

May 31, 2023May 29, 2023 codef4devs

Protecting the excel workbook with a password is the best way to prevent others from accessing data in your excel workbook. This ensures that the data in workbook will be accessed by only authorized person, […]

Leave a commentExcel

Easy Steps to Create Drop-Down List in Excel

August 2, 2020August 9, 2020 codef4devs
Drop Down list Excel

In excel, if you want user to enter a value in a cell only from a set of pre defined list, drop-down list is the best way to do so. A drop down restricts a […]

Leave a commentExcel

Excel Keyboard Shortcuts List to Save Your Time

July 27, 2020August 1, 2020 codef4devs

As every application has its own keyboard shortcut keys, Microsoft Excel also has a variety of keyboard shortcuts you can use to boost your work speed and make things more easy. Here is a list […]

Leave a commentExcel

Categories

  • C#
  • Excel
  • JavaScript
  • Miscellaneous
  • MySQL
  • Python
  • Uncategorized
  • VBA
  • WordPress

Recent Posts

  • Python code to Find a Cell in Excel having Specific Date
  • Python Error: ‘module ‘win32com.gen_pyxxxx’ has no attribute ‘CLSIDToClassMap’ Solution
  • Group Concat in Excel-Concatenating Cell Values based on Grouping Rows
  • Python: Send Email from Outlook with Attachment
  • How to Add Checkbox in DataGridView in C# Windows Form Application
Copyright © All rights reserved.